Export reports to Excel

[Mike Huston]

I have asked MS several times over the years and got
a "No" answer.

Is there anyway to export reports, like "Cash Flows" into
an Excel worksheet or at least a dilimited file?

Thanks
Mike

 

[Mike Glen]

Hi Mike,

Welcome to this Microsoft Project newsgroup

Please see FAQ Item: 16. Project Viewer.

FAQs, companion products and other useful Project information can be seen at
this web address: http://www.mvps.org/project/

Hope this helps - please let us know how you get on

Mike Glen
Project MVP

 

[JulieS]

Hi Mike,

Although there is no direct way to export a report to
Excel, you should be able to get the "Cash Flow" report
data exported to Excel using the "Analyze Timescaled Data
in Excel" option from the Analysis toolbar.

Hope this helps.
Julie

 

[John]

Mike,
I think what you meant to ask was, "Is there any way . . " instead of,
"Is there anyway . . ." I am surprised that whoever you asked at
Microsoft said "no". The answer is definitely, "yes". Julie and Mike
both gave some options but there is yet another method - use VBA. With
VBA you can not only export any Project data into Excel but also format,
manipulate and graph it in any way desired.

John

 

[JackD]

As John says, VBA is the way.
What exactly do you want to export?

-Jack

 

[Mike Huston]

Julie,
I took a while to go back and look at your response, but
thank you for the tip. Just what I was looking for! And
I didn't have to resort to learning VBA.

Mike