Save Plan Linked to Resource Pool

[Ian]

Hi

How can I use code to save more than one plan linked to
the same resource pool.

If I use Display Alerts = False, by default it selects
the 'Update Resource Pool' option and then stops after the
first plan.

I do not need the resource pool to be saved so how could I
save the plan and tell it to not update the resource pool.

Thanks,
Ian

 

[Rod Gill]

Have you tried recording a macro of you doing this manually? If not, try it
and see what gets recorded for you.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[Ian]

That was the first thing I tried. Unfortunately all it
comes up with is "FileSave". It doesn't record anything
for the fact that I clicked 'Cancel' to the 'Update
Resource Pool' question.

Thanks,
Ian

 

[Rod Gill]

So why don't you want the pool updated? If you only need an occasional view
of the pool for reporting, get rid of the pool and record a macro to create
a consolidated view (with no links to projects so resource details are all
copied to the master) to report on resource needs. This makes everything
simpler, quicker and less likely to corrupt.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[Ian]

I'm performing a weekly back-up of 2 schedules with a
linked resource pool, an historic file, and a master file
linked to all 3 (we take a copy of the master as the back-
up). There are no resource updates when I run the back-up
so the pool doesn't necessarily need to be updated (it
doesn't matter either way). I do have to save both the
files linked to the resource pool though as we track date
changes on a weekly basis using formulas to show if the
dates are different to the previous week. Therefore the
relevant fields have to be re-set (we have fields that
hold the dates at the point of back-up, and fields that
have formulas to check if they have changed).

This process is fully automated by a macro except for 2
points in the process. The status date and notes on the
master file are updated and the master file is saved, at
this point I have found no way to get around having to
click 'No to all' so it only saves the master file and not
the plans it's linked to. Also, I have to click 'Cancel'
when it asks me if I want to update the resource pool
after save each schedule file otherwise the macro stops
after saving the resource pool on the first occasion.

 

[Guest]

So what you are saying is that it can't be done?

-----Original Message-----
So why don't you want the pool updated? If you only need an occasional view
of the pool for reporting, get rid of the pool and record a macro to create
a consolidated view (with no links to projects so resource details are all
copied to the master) to report on resource needs. This makes everything
simpler, quicker and less likely to corrupt.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/



.

 

[Rod Gill]

Hi,

Firstly, the master file only has the links to the projects, and no other
task data as well. It therefore makes a pretty useless backup!! Save the 2
schedules. The pool and master file you can recreate from the schedules, but
without the schedules you can't do anything.

I don't understand why you can't just save the pool, the 2 schedules and the
master file. This is the safest way to avoid file corruption.

Try recording a macro of you dong the process manually and see what
parameters Project records.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/