Identifying subtasks exported into Excell

[Bob]

I am exporting MS Project tasks into Excel. How can I identify the subtasks
exported from MS Project? In Excell al the tasks are left justified.

Thanks in advance.

 

[John]

I am exporting MS Project tasks into Excel. How can I identify the subtasks
exported from MS Project? In Excell al the tasks are left justified.

Thanks in advance.

Bob,
I think what you really want is the outline information to export. If
you include the Outline Level in the export map you can re-create the
indenture in Excel. However, fellow MVP, Jack Dahlgren has a nifty
little VBA macro on his website at:
http://masamiki.com/project/macros.htm
that will do it for you. Look for his macro called, "Export hierarchy to
Excel".

Hope this helps.
John
Project MVP