Open and Save all projects in a Database

[Ian Wolstenholme]

Hello,

Does anyone know how I might be able to cycle through all projects in a
Database, open each one and save automatically.

If we change the Enterprise Global we want to make sure that the projects
are picking up the new defaults for some fields (esp for calculated fields
with a formula). This requires us to open and save every project in turn.
With over 350 projects thats tedious to do manually ?

Does anyone have an idea on how this might be done as a macro ?

Much appreciated !

Thanks

Ian

 

[Rod Gill]

Hi,

First create a connection to SQL Server and create a recordset to read the
titles of all projects in the MSP_Projects table.

Then loop through each project, re-calculating and saving each one before
closing.

I would do it all in Project VBA. Record a macro of you manually opening,
recalculating then saving a project to use in the body of the loop and
you're just about done apart from substituting the name of the project with
the title from the recordset.

Plenty of help in msdn.microsoft.com for the recordset part.