Scripts

[atheil]

We need to extract data (e.g. Milestones) from multiple MS Project 2003 files
and export that info to a report. Does Project have a way of doing this or
would it be a Windows script?

Thank you
Aimee

 

[Mike Glen]

Hi Aimee,

Welcome to this Microsoft Project newsgroup

You could try Project/Filtered For) /and select milestones. As for
exporting, please see FAQ Item: 16. Project Viewer.

FAQs, companion products and other useful Project information can be seen at
this web address:http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[atheil]

We need to extract data (e.g. Milestones) from multiple MS Project 2003 files
and export that info to a report. Does Project have a way of doing this or
would it be a Windows script?

Thank you
Aimee

We are looking for an automated way of extracting the data across multiple
files instead of opening/filtering/exporting/closing on hundreds of files;
that is why we thought a macro or script might be the answer.

 

[Mike Glen]

In which case, Atheil, try posting on the developer newsgroup. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[Rob Schneider]

We are looking for an automated way of extracting the data across multiple
files instead of opening/filtering/exporting/closing on hundreds of files;
that is why we thought a macro or script might be the answer.

Aimee,

Yes, a script in VBA inside of Project would do this. Basically, it
would be something like

1. read the list of all the files
2. open each file and loop through all tasks
3. look for tasks with milestone field = yes
4. gather the info you want about that milestone task and save in memory
or a file
5. put that gathered info somewhere (probably write to a file)
6. write a report from the data in the file (probably using Access,
Excel, or write your own in any language, or do it manually)

 

[atheil]

Rob,

Are you saying that a MS Project script would have to be written for each
file or 1 script to do all the files?

Thank you!
Aimee

 

[atheil]

Thank you.

In which case, Atheil, try posting on the developer newsgroup. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[Mike Glen]

You're welcome, Aimee

Mike Glen
MS Project MVP

 

[Rob Schneider]

Step 1 (below) is to get the list of the files (probably putting it in
array), then loop through that list of files. You'll want to get a
programmer to do this for you, or use this as a learning exercise.

 

[atheil]

Hi Rob.

Do you have any suggestions for getting the specific VBA code to do this?

Thanks again!
Aimee