Hi All,

I tried searching for it but couldn't find any good concrete information. Can someone please point me in the right direction !

I am trying to export the tasks, milestones and associated data from MS Project 2010 to Excel 2010. Right now what I do is I chose the option to "save as" an excel (.xlsx) file and I have saved the map that I have created for the data that I want to export. But every time I have to export the data, I have to manually do a save as.

I tried recording the macro using "Record Macro" but it's not clean.

Can this process be automated? Is there a way of cleanly automating this process? The structure of the Project file and Excel file does not change so I can essentially use the "map" that I have saved but am looking to get more information on it to learn/read about it.

Any help is really appreciated. Thanks and regards.