Auto Update Links B/W the Projects

[Ramana Murthy]

Hi,

I have 2 MS Project Files, one is Activity Plan and another is Milestone
Plan. In Activity Plan i have defined tasks and Milestone plan i have defined
only milestones which are linked to the tasks in the Activity Plan
(Predecessors). Is there any way when i update Tasks in the Activity Plan, it
should autometically update the data in the Milestone plan with out opening
the file manually???

This has to be done using the Macro

It would be great, if i get any help ???

 

[Rod Gill]

Hi,

Why not one file? You can use filters to show only the tasks you want (EG
milestones).

You can use VBA to automatically open the Milestones file then update the
tasks.

You could save the milestones project in a database then use VBA to update
the dates in the database.

 

[Jan De Messemaeker]

Hi,

If you insert both projhjects in a same file, opening that file will
automatically open both inserted files.
HTH

 

[Ramana Murthy]

Hi,

My requirement is like this, i can't combine activity plan with milestone
plan.
In the Milestone Plan, i have linked the Predecessors to activities in the
activity plan. When i update the Activity Plan say dates and closes the plan,
when i open the milestone Plan a popup window (LinksBetweenProjects) is
showing, if i say all and close it is updating the dates in the Milestone
Plan.

The same thing i want to do using the macro without opening the milestone
plan, it should happen from the activity plan itself. I don't want to use the
database.

 

[Jan De Messemaeker]

How could the milestone plan be updated when it is not opened?

 

[Ramana Murthy]

Hi,

It means can be open through macro not manually.......

 

[Jan De Messemaeker]

Hi,

I understand now.
Supposing you want to update the milestones plan each time yoàu close the
tasks plan, this could be done like this:
Make sure the tasks project is open
In VB Editor (Alt+F11), in the leftmost window select VBAProject (nameof the
taslksproject
If necessary open (the +sign) Microsoft project OObjects and double-click
ThisProject
Two small line windows appear.
In the leftmost one select Project
Then in the rightmost one select Before Close
After the line Private Sub Project_BeforeClose write the following:

fileopen "The address of the milestonefile"
fileclose pjsave

Hope this helps

 

[Ramana Murthy]

Hi

Thanks for the help, i can write the code in the before save event, but what
i need is if i update some dates in the activity plan and save and close,
then if i open the Milestone Plan it pops up the LinksBetweenProjects window
with all the tasks and difference if i say all and closed it updates
automatically in the milestone plan.

Can this be done using the macro.

 

[Jan De Messemaeker]

Hi,

Did you try?