I want to launch MS Project to open a file, run a macro then close

[Jane Kirby]

I need to automate the collection of metric data from multiple MS Project
files. For each MPP file, I want to launch MS Project, run a macro to save my
data, then close. So far, I have been able to call up Project with a command
like the following
"C:\Program Files\Microsoft Office2003\OFFICE11\WINPROJ.EXE"
-"E:\Documents\Metrics\MyProject.mpp"

I have no idea how to pass in a parameter to get the macro run. Can this be
done?

Also, I would prefer to run MS Project silently, so that the person running
the batch file does not see the GUI zoom into view repeatedly. Is this
possible?

 

[John]

I need to automate the collection of metric data from multiple MS Project
files. For each MPP file, I want to launch MS Project, run a macro to save my
data, then close. So far, I have been able to call up Project with a command
like the following
"C:\Program Files\Microsoft Office2003\OFFICE11\WINPROJ.EXE"
-"E:\Documents\Metrics\MyProject.mpp"

I have no idea how to pass in a parameter to get the macro run. Can this be
done?

Also, I would prefer to run MS Project silently, so that the person running
the batch file does not see the GUI zoom into view repeatedly. Is this
possible?

Jane,
This question might get more response if posted on our sister newsgroup,
microsoft.public.project.developer, but here's something that might help.
Go to fellow MVP, Jack Dahlgren's website at:
http://masamiki.com/project/macros.htm
Jack's site has some very useful information for the type of process you
want to do. If Jack's site doesn't fully answer you questions, then post
back to the above newsgroup.

John
Project MVP

 

[Jane Kirby]

John,
Thanks for the info. I didn’t find an answer there, so I’ll post my question
on the developer site. Being a first time user of this site, I haven’t found
my way around yet.
Thanks