How do I export custom MS Project reports into Excel?

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
Wed May 11 17:50:11 CDT 2005

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

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
.
"Dxing5304" <Dxing5304@discussions.microsoft.com> wrote in message
news:DE4E47E4-D07F-46C6-A452-42B0BE601314@microsoft.com...
> 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.

John
Wed May 11 21:42:52 CDT 2005

In article <DE4E47E4-D07F-46C6-A452-42B0BE601314@microsoft.com>,
Dxing5304 <Dxing5304@discussions.microsoft.com> wrote:

> 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