MS proj2002 -export cost report to Excel

[Aengineer]

Any tips on How to export the cash flow cost report (per month) to Excel would be appreciated.

 

[IRstuff]

Do you need something fancier than copy and paste?

TTFN

 

[Aengineer]

I would like to use the cost information which is displayed in the cost report- eg tasks with costs - per month.

When I run the report it does not give the option to export the data and I have not been able to copy it in the print prview mode.

I am wondering if I can get this report to Excel for analysis.
Copy and paste would be a good start.


Jeff

 

[IFL]

You could actually write a macro that exports the cashflow data and damps it directly into Excel (I have done it and it works perfectly.

 

[Aengineer]

IFL (Civil/Environme),

Is it possible for you to send me a copy of the macro??

I am also interested in linking XL to the resources costs in MS project so that I can set the labour costs/prices without having to input them manually.
Also interested in any other interesting macros??

email to: jacaranda@pacific.net.au

Jeff