Exporting a MS Project report into Excel?

P

Peter B

How can I export a MS Project cost/cash flow report into Excel and save as a
seprate file to the gant chart?
 
P

PY & Associates

I have been searching high and low, but never find a way.
I complied my own macro to do it.
 
J

John

PY & Associates said:
I have been searching high and low, but never find a way.
I complied my own macro to do it.

PV,
That's correct, I know of no freely available utility for exporting the
equivalent of Project's built-in reports to Excel. The closest thing
available is the "analyze timescaled data in Excel" utility and then a
whole lot of manipulation is required to get all the report information
and format it. A custom VBA macro is the way to go (or perhaps a query
directly to the Project database).

John
Project MVP
 
P

PY & Associates

I haven't found anything useful YET from "Trask Usage view and display Cost
in the timescale value". Will try again. Busy today.
 
J

John

PY & Associates said:
I haven't found anything useful YET from "Trask Usage view and display Cost
in the timescale value". Will try again. Busy today.

PY,
?? Sorry, you lost me.

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top