How to identify Project Server save and publish is complete (in co

[Nijk]

Hi, First off please forgive my lack of knowledge - I am not a developer.
However I can usually get by with macros.

I use Project 2007 with Project Server. Each week I open 20 project plans in
Project, then update 2 fields then save and publish each project. It is time
consuming and can be automated.

The problem is this:
I can write code to open the projects from the server and update the fields
but I have no clue how to automate the save and publish. The biggest obstacle
is how do I identify that a Save to the server is complete so i can step on
to the Publish function (same applies to Publish so I can step onto the next
project).
When I do this manually I can see the status bar message in Project "Save
Job Completed Successfully" but is it possible to identify that in code?

Any ideas, thoughts or lines of code would be very greatfully received.
Thanks in advance
Nijk

 

[Rod Gill]

First record a macro of you manually publishing and saving, then use the VBA
Timer function to create a delay. Experiment to see how long you need to
leave each project to completely save.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Nijk]

Hi Rod,
Thanks for the response.
Its never that simple The delay is highly variable for both the save and
publish functions. So hardcoding a delay will not work unless I set an approx
2 min delay on both the save an the publish to account for the 'busy' periods.

Once again, thanks for your input.
Kind regards
Nijk