Import MS Project to Excel 2000

[ads_3131]

Hi All,

Is it possible to import a full MS Project file into excel 2000 via VB? Been looking into this and so far no luck :(

[Yongle]

I do not think you need VB.
I do not have Project on my machine to test this but you could try this:

Rather than importing a project into Excel try saving a project as an Excel file using File Save As and selecting xls as the file type.

[ads_3131]

Hi Yongle,

I would like to import from excel due to being around 20 MS project file which get updated weekly rather than manually one by one open save as etc.

[Yongle]

Suggest you try the "save as" to see if it gives you what you want first
Hopefully that will be a good first step
If it does, then can use VBA automate the process, saving all projects weekly, pulling together summaries across projects etc

If the standard "save as" does not provide everything you require then obviously a different approach would be necessary.

[ads_3131]

Save as works for me however so does the following to auto-update:

={MSProject.Project.9|'\\ROB27\DATA\Proj\3\318\31889\Programme\Current\3188 9-PROG-001D.mpp'!'!LINK_4'}

However it will not allow me to chance the file path... would it be possible to reference another cell containing the file path?

[Yongle]

Sorry but I am unable to answer that question but perhaps others reading this could jump in here....