Macro to Automate Update Project Progress

[Iain Carlin]

I have a client who uses PWA Timesheets for Resources to update tasks.

To update the Plan, they use Update Project Progress in Collaboration and a
Rule to accept all updates for the Plan.

The Rule uses an ActiveX object (pjupdate11.ocx) to control the update of
the Web information into the Plan.

My client wants to eliminate the step of having to open the web page and
would like a macro to perform the update when the Project is opened. Is there
a VBA method that can be called to do the update?

Regards,

Iain Carlin

 

[Iain Carlin]

I eventually found a solution to this...however I reckon that Microsoft might
do well to look at incorporating a better method of achieving the same result
into the Project SDK.

Basic steps in my solution are:

1. IN PWA, set up a rule to accept all task updates.
2. Copy and Edit the tasktransactions.asp file on project server to include
a timer to automatically fire the script that runs the above rule.
3. Create a macro/console app that opens the project and then the new .asp
page via a custom Project Guide, this will fire the running of the update
rule and update all the tasks that have been submitted.
4. The console app needs to wait for the 'Save Project -> OK, OK to All,
Cancel' dialog box that comes up after the rules are run then submit that
window (using SendKeys/Send Message etc)
5. Console app can Save and close the project.

Like I said, I found a number of people asking on the web for how to do this
and no answers. The above is not elegant nor ideal and since people are
asking for the feature, it would be good if Microsoft made it possible/easier
via the SDK or PDS in a future release.

Iain Carlin