macro for reading file frm MS Project to MS eXCEL

[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

 

[John]

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

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