automatically extract data from project to excel

[chris_culley]

Hi All,

Potentially a tricky one (not least because I might be going about
doing it in a bit of a backwards way)...

I've got a large amount of data in a MS Project file, which is too much
to be able to be able to use as a summary document. To this end, I've
created a series of macros which use the project data to prodcue
summary charts and graphs as required - this is done and dusted with...

The bit that remains, and that I'm struggling with, is how to simplify
the process. I want a single button, in excel, that when pushed does
the following:

1. Opens up hte relevant Project file
2. extracts the required fields (for example, name and start date) from
that project file and saves them elsewhere in the workbook.
3. closes back up the project file - and lets my other macros do their
magic on the resultant data...

To be honest, I can' t do any of these - but I'm particularly stumped
by 2. I've thought about trying to save the data in project as an .xls
(using a template as required), or getting excel to run some macro in
Project which could do the extract.... Any help with these or examples
of bits of code that might help would be fabulous!


Thanks in advance....

Chris

 

[JD]

Chris,

The process for working with excel and project is covered here:
http://zo-d.com/blog/archives/programming/working-with-other-applications.html
Of course you can do the same thing from the excel side - using it to open
project rather than project opening excel.

Since you are working with existing macros you probably should look at this
article as well:
http://zo-d.com/blog/archives/programming/working-with-modules-and-macros.html

That should give you a good start towards where you want to go.

-Jack
http://zo-d.com/blog