How do I export ms project data to excel using VBA?
How do I export ms project data to excel using VBA?
(OP)
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!!!
Many thanks in advance!!!





RE: How do I export ms project data to excel using VBA?
RE: How do I export ms project data to excel using VBA?
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
RE: How do I export ms project data to excel using VBA?
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.