Extracting Project Data in Excel - Formatting is Pathetic

[RajeevAsthana]

Hi,
When I 'Save As' Excel, the output Excel is pathetic. All formatting such as
indentation, bold etc. are lost.

Is there a better way? I create many projects with varying tasks.

Thanks in advance,
Rajeev

 

[John]

Hi,
When I 'Save As' Excel, the output Excel is pathetic. All formatting such as
indentation, bold etc. are lost.

Is there a better way? I create many projects with varying tasks.

Thanks in advance,
Rajeev

RajeevAsthana,
Using an export map, such as "Save as Excel Workbook", only captures the
raw data which is generally unformatted text. The formatting applied
when you view the file in Project is applied by the Project application.
There are various ways to capture formatting information when exporting
Project data to Excel (or any other application) but they won't
necessarily be convenient.

If you want to capture the indentation structure you might want to go to
fellow MVP, Jack Dahlgren's website at:
http://masamiki.com/project/macros.htm
and take a look at his macro "Export hierarchy to Excel"

Capturing font formatting (e.g. bold, italics, etc.) is a little more
interesting because those properties are not directly readable with VBA.
It can be done (using VBA) but only with indirect methods.

John
Project MVP