Saving all projects as .MPP from ProjectServer DB using VBA

[Deve]

Do you know a way to export all projects as .MPP out of a Project Server
database?

The process should be automated, not manually saving projects using SaveAs.

I think Application.FileSaveAs method is a way, but I need some VBA expert
to help here with the code.

Many thanks in advance

 

[Jack Dahlgren]

It is pretty simple in VBA.
Record a macro of you doing a single project to get the syntax for
filesaveas.
The hardest part is getting the list of projects.
I just download the list of projects from PWA and have project read through
the list and open each in turn. Once you have them open, do the saveas and
then close the project. Go to the next value in the list.
You can make it much fancier by allowing people to browse to a list of
projects or write code to retrieve the projet names directly. But the simple
approach could be up and running in a short time.

-Jack Dahlgren

 

[Jan De Messemaeker]

Hi,

There is a routine in Rod Gill's book doing that.