Export MS Project to Excel indentation

[omp]

1. How to add the WBS name in MS Project?
For instance, I want to specify the WBS names, Phase, activity,
subactivity, task.., rather than WBS number, 1.0, 1.1, 1.1.1....

2. Can I export MS Project WBS indentation as appeal in MS Project view to
Excel?
For instance, in MS Project the indentation is like:
1.0 Project I
1.1 Project Management
1.1.1 Schedule Meeting
after exporting to excel the indentation is like:
1.0 ProjectI
1.1 Project Management
1.1.1 Schedule Meeting
How to export to excel without changing the indentations?

thanx

 

[Rod Gill]

Not available out of the box I'm afraid. When I last needed to do it for a
client I exported the task name and Outline level then had a macro to do the
indenting.

 

[JulieS]

Hi omp,

See Jack Dahlgren's "Export hierarchy to Excel" macro at:
http://masamiki.com/project/macros.htm

Hope this helps. Let us know how you get along.

Julie