macro for reading file frm MS Project to MS eXCEL

A

amit

Hi,

Could anyone tell me how do I access and read a file in MS project onto a MS
Excel sheet(i.e data dumping from .mpp file to .xls file)?
I need this to be programmatically done by writing a macro in the MS Excel
vb Editor.

It would be great if you could give me the code for this.

Thanks,
Amit
 
J

John

amit said:
Hi,

Could anyone tell me how do I access and read a file in MS project onto a MS
Excel sheet(i.e data dumping from .mpp file to .xls file)?
I need this to be programmatically done by writing a macro in the MS Excel
vb Editor.

It would be great if you could give me the code for this.

Thanks,
Amit
Click to expand...

Amit,
Why not try fellow MVP, Jack Dahlgren's macro called, "Export hierarchy
to Excel" and modify it to work in reverse (i.e. on the Excel side from
Project to Excel). You can view Jack's code on his website at:
http://masamiki.com/project/macros.htm

Hope this helps.
John
Project MVP
 
Top