Automatically Update Project

[Mike]

Hi

Every day, I have to open de project file, go to "Tools->Tracking->Update
Project".
I select "Update work as complete through" with "Set 0% - 100% complete"
option.

I have to change de "Date" and press ok.

Is there a way to do this automatically.
Is there a way to do this even without open de projecto file?

Thanks a lot.

 

[Jan De Messemaeker]

Hi,

It can be done with aVBA procedure but do you really want that?
In your world (Utopia?) do all tasks always happen as planned?
Curious.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Mike]

Well.

It does not happens in all my projects. These projects only keep track of
the time that one person is "dedicated" to do work for a special kind of
clients. But I want to keep tracking of this, and see it in my reports.

Do you have any code examples of VBA to do this?

 

[Jan De Messemaeker]

Hi,

With your project open, Alt+F11 to open VB Editor, upper left window open
VBAProject(name of your project) doubleclick ThisProject, in the small
windows of the right part look for Project and Open nd between the two lines
that appear insert the following:
updateproject all:=true,updatedate:=vba.Date,action:=pj0or100percent

HTH



--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf