Macro - Open, Save , Publish

[CQ]

I have a long list of Projects - 94 at current count. I need to build a
macro (or stored procedure, or whatever) that goes out, opens each one up,
reschedules the work and then saves\publishes and then closes it and goes to
the next one in the list. Thoughts?

 

[Rod Gill]

As long as the macro is run from a copy of Project already logged in to
Project Server, that's straight forward. Record a macro of you opening one
project, updating, saving and publishing it. Then edit the code to loop
through all projects. I think you will need to read the list of all projects
using PDS (see msdn.microsoft.com) or more simply by reading the list
directly from the Project Database on SQL Server.