How do I export custom MS Project reports into Excel?

[Dxing5304]

I've created a custom report in MS project but it only allows me to print the
report. I would like to export the data into excel.

Can this be done? I'm using Project 2000 currently.

 

[JackD]

No it can not be done. You need to use VBA code to export the data needed
for the report. Sorry.

 

[John]

I've created a custom report in MS project but it only allows me to print the
report. I would like to export the data into excel.

Can this be done? I'm using Project 2000 currently.

Dxing5304,
I agree with Jack - VBA will give complete flexibility to export data
for any report you need. However, there may be a couple of alternate
approaches depending on what data you need in the reports.

If you are only dealing with static data (i.e. not timescaled), you can
use an export map to save the data to an Excel spreadsheet. Once in
Excel, the report can be created as necessary. If you need timescaled
data in the report, you could try the utility, "analyze timescaled data
in Excel" found on the analysis toolbar. Again, once the data is in
Excel it can be formatted for a report.

Hope this helps.
John
Project MVP