×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

MS proj2002 -export cost report to Excel

MS proj2002 -export cost report to Excel

MS proj2002 -export cost report to Excel

(OP)

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

RE: MS proj2002 -export cost report to Excel

Do you need something fancier than copy and paste?

TTFN

RE: MS proj2002 -export cost report to Excel

(OP)
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

RE: MS proj2002 -export cost report to Excel

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.

RE: MS proj2002 -export cost report to Excel

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources