Macro to set pool for consolidated projects

[Training Goddess]

I found a macro on the Microsoft website:
http://support.microsoft.com/default.aspx/kb/187386

but found that it didn't work in Project 2003.

It says applies to version 98/2000, but I couldn't determine why it wouldn't
work in the 2003 version as well.

Can anyone help?

Thanks!

 

[Jan De Messemaeker]

Hi,

I gave it a look and don't see any obvious rason
When you run it, on which statement does it stop?
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[John]

http://support.microsoft.com/default.aspx/kb/187386

Training Goddess,
Pardon me for bumping in but I think most of the MVPs no longer use or
have Project 2003 loaded - I do.

I tested the macro on a master file I have and it failed to activate the
subprojects when needed. I spent a few minutes trying to figure out why
but came up empty. A workaround is to call up the new window dialog and
then select the available subproject. Change the following line of code
and see if that helps.

From:
WindowNewWindow Projects:="" & oInsertedProj & ""

To:
WIndowNewWindow ProjectsInsertedProj, howdialog:=True

If I had more time I'd figure out why the existing code doesn't work and
then fix it for you. But, time I don't have. Sorry.

John
Project MVP