Master Project Plan - Resoruce Usage across Multiple Projects

[Jerryinnc]

Is anyone aware of a VBA macro that is available to look at multiple
projects and see the resource workload acrss all projects. I heard that
there was one available through Project Learning. But can't find anything on
their website.

Thanks

 

[Rod Gill]

Hi,

The macro simply puts all .mpp files in a nominated folder into a single
resource pool then undoes the pool on demand. This is more reliable that
keeping a pool as when files are renamed, moved, overwritten etc. there is a
high chance of corruption. Link is:

http://www.msproject-systems.com/microsoft-project-macros/resourcepool.htm

 

[Jerryinnc]

I looked at the download info and it talks about MS Project 98 or 2000. Is
there a 2003 solution that can be used with a master plan with inserted
projects?