Exporting Heirarcy to Excel

[scott_hanebutt]

I have modified Jack Dahlgren's Export hierarchy to Excel to create a weekly
update form. Each tab in the Excel file displays tasks for a different
resource. The problem I am having is displaying the summary tasks. I know I
can use the .outlineparent property to find out what the parrent is however I
don't want to display all parents directly before each task. I want to show
the parrent and then all tasks by that resource under it.

for example I want to show

Summary
Summary
task x
task a
task p
task d
Summary
task g

I don't want it to look like
Summary
Summary
task x
Summary
Summary
task a

My code is quite lengthy so I am not posting it. If however you believe it
would help I will post it or send you the module.

Any help would be greatly appreciated.
Scott Hanebutt

 

[Rod Gill]

That breaks the structure of how tasks and resources are organised in
Project. So to get what you want, you will need to use VBA to create an
index in a spare column, then sort it to get what you want.