Automatically Update Master Project

[skiggs]

Good Day, I have set up a 'Master' project with 'Sub Projects' - my goal is
that when people make changes to sub projects it is automatically updated
upon opening the Master. The files are linked and will update if I 'expand'
them - but won't update until I do that....

I appreciate the help

 

[Mike Glen]

Hi Skiggs,

Welcome to this Microsoft Project newsgroup

That's how it works. The Master just holds placeholders for the inserted
projects and thus cannot update in the Master until you expand them.

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[tommcbrny]

As a follow-on question to this, if I open only the Master file and do
updates in the individual projects within, are the individual project files
updated automatically?

Thanks,
Tom

 

[Gérard Ducouret]

Hello Tom,
Yes, the individual project files are updated automatically.

Gérard Ducouret

 

[David Pedersen]

I do this (update inserted projects manually) all the time...what a pain.
Your note made me think about it...then I recorded a macro in which I
selected all tasks (by clicking the gray button above the first task number),
used the control to show "all subtasks", and then used the same control again
to show only "subtask level 2". Now I can run a macro via keystroke that
does all of the updating for me.

Now if I could just run the macro automatically when opening up the master
file...

Anyone know if it is possible to run a macro automatically on startup?
David

 

[JulieS]

Hello David,

If you insert the macro in the Open event of the project file it
should fire on opening. Display the Visual Basic Editor (VBE) through
ALT + F11.

In the project explorer, select "ThisProject (Your Master file name)".
In the code window, click the Object drop down (on the left) and
select Project. In the procedure drop down (right) select Open. Copy
and paste your macro between the first line and the last line (End
Sub). Delete the additional End Sub statement.

Save and close the project file. When you re-open the macro should
fire automatically.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[David Pedersen]

Julie,
Thanks! Works perfectly once I changed the macro security setting to allow
macros to run unimpeded.
David

 

[JulieS]

You're welcome David and thanks for the feedback.

Julie