How do I export ms project data to excel using VBA?

[MAIMPL]

I need ms project data to determine a lot of metrics based on actual project effort numbers. How do I export project planning data to Excel using VBA?

Many thanks in advance!!!

 

[RGStewart]

Would copying the cells from MSP (while in a view like gantt) and then simply pasting into Excel do what you want?

 

[LamarAt]

One thing you may consider is creating a map using the Export Wizard. Once you have created a map containing the fields you wish to have in Excel you can create a macro to dump the data to Excel.

But copying the data will also work well for most all situations.

Example macro:


Sub Export_To_Excel()

Sort Key1:="Date10", Renumber:=True
OrganizerMoveItem Type:=7, FileName:=ActiveProject.Name, ToFileName:="Global.MPT", Name:=" MY MAP"
FileSaveAs Name:="C:\Schedules\MY_SCHEDULE.xls", FormatID:="MSProject.XLS5", map:=" MY MAP"
End Sub

 

[Pesque]

Have you tried the "Analyze Timescaled Data in Excel..." feature?
There you can select every field you need to analyze!
I don't remember where it is hidden, anyway just select the "Analysis" Toolbar and from there just click the button.
Bye.