Resource Properties Not Available - Common Resource Pool

[JoeP]

A new project is created when you select Open All Sharer files while opening a common resource pool. With Project 98, this new project behaved like any other project and you could, for example use "ActiveProject.Resources.Count" to return the number of resources associated with the new project

I find that with Project 2002, I cannot seem to get any resource properties for the new project created as described above. For example, even though I have over 200 resources that show up on the resource sheet for Project 2, the VBA statement "ActiveProject.Resources.Count" returns 0

Any idea how to get the resource and assignment properties when working within the summary project that is created when you open a common resource pool with all sharer files (under Project 2002)

Thanks in advance

 

[JoeP]

Answered my own question (finally
needed to change from

For Each res In ThisProject.Resource
For Each asgn In res.Assignment

to

For Each subprj In ThisProject.Subprojects 'subprj has been delcared as a Subprojcet typ
For Each res In subprj.SourceProject.Resource
For Each asgn In res.Assignment

Takes much longer and is not as clean. I suppose there must be some benefit to the added abstration but I have yet to discover any such benefit

I hope this helps someone else
joe

 

[Rod Gill]

Hi,

If you create a master project with links, then the resources live in the
subprojects. If you create a master project without links, then the
resources and all tasks live in the new project file.

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

Answered my own question (finally)
needed to change from:

For Each res In ThisProject.Resources
For Each asgn In res.Assignments

to:

For Each subprj In ThisProject.Subprojects 'subprj has been delcared as a Subprojcet type
For Each res In subprj.SourceProject.Resources
For Each asgn In res.Assignments

Takes much longer and is not as clean. I suppose there must be some

benefit to the added abstration but I have yet to discover any such benefit.