Exporting specific data from MSP 2003 to Excel

A

Andrew

Guys

I work in MSp my surveyors work in excel, I want to give them a work package
procurement schedule in excel that is based on the MSP procurement schedule.
the schedule is a list of activities from tender information through to start
on site (sorry for the sucking eggs part, just in case someone didnt get it).
I know this can be done with VBA - but I do not know how to programme in VBA
and I do not have the time - I am being pressed for some answers. Is there
anybidy out there that can give me some coding that would do this?. I know I
should go purchase Rods book, but as I have said I am pushed at the moment.
If anyone is feeling generous it would reaaly be appreciated, anyway thanks
in advance

Andrew
 
J

Jim Aksel

The solution may be easier than you think. Create a filter in MS Project
that shows only the tasks you want to export. You may need to do it one Work
Package at a time.

Use the Analyze Timescaled Data in Excel wizard from the analysis toolbar.
This will export useful information for you.

See if that helps. If not, please post a more specific question. Glad to
help.
--
If this post was helpful, please consider rating it.

Jim

Check out my new blog for more information:
http://www.msprojectblog.com
 

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