Exporting Data from Project into Excel

[mmp190]

I need to find a macro that can link to our Project Master Schedule (which is
updated weekly) and look up a Unique ID (or Sub UID) and return the Baseline
finish and Forecast finish into an excel sheet into specific cells.

I have heard that t VBA script can be corrupted or erased if files are
updated, is this true

Help?

 

[Jan De Messemaeker]

Hi,

I never had any problem with VBA code before using it at a customer running
Project Server, where there are potential problems with the Enterprise
Global.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[mmp190]

Thats not my question though. I need to know HOW to create the VBA script to
run the instructions below.

 

[Rob Schneider]

Best advice is to repost on microsoft.public.project.developer where the
VBA experts hangout. Also, suggest you hire a programmer who can work
this out for you. They can allay your concerns about corruption and
erase files (which surely will not happen from VBA unless the VBA is
specifically programmed to erase files).

 

[Jan De Messemaeker]

Hi,

Here are a few key objects/methods

For each subp in activeproject.subprojects
set sbpr=subp.sourceproject
(then you can handle sbpr as an individual project)

next subp


To write to Excel
dim xlapp as excel.application
set xlapp=createobject("Excel.aplication")

....
dim job as task
xlapp.activeworksheet.cells(rox, col).value=job.finish
xlapp.activeworksheet.cells(rox, col+1).value=job.baselinefinish

This should help you get underway...
Hope this helps,


Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf