Resources in Subprojects

[Sebastian Cordoba]

[Project 2003] Hi everyone.

I've created a Macro to look at all Resources in the Active Project so that
I can create an array with as many positions as resources.

Part of the code is:

For Each res In ActiveProject.Resources
If Not (res Is Nothing) Then
counter = counter + 1
End If
Next res

After that, I have another loop to collect certain information about each
resource and keep it in the respective position of the array.

The problem is: when I have a master project this doesn't work. It just
skips this section of the code. So, how can I Identify all of the resources
in the Master Project and avoid duplication? (subprojects share some
resources [local resources]).


Thanks for your help.

 

[Rod Gill]

You either need to create a Resource pool or you need to create your master
projects by clearing the Link option. This makes copies of all Task and
Resource data but also consolidates all resource information.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Sebastian Cordoba]

Hi Rod.

I'm kind of new in the VBA world, so I need to ask you something: How can I
clear the link option? Does it create a new project?

Regarding the resource pool, I'm not able to implement it since we have
Project 2003 Standard Edition.

Thanks!

 

[John]

Hi Rod.

I'm kind of new in the VBA world, so I need to ask you something: How can I
clear the link option? Does it create a new project?

Regarding the resource pool, I'm not able to implement it since we have
Project 2003 Standard Edition.

Thanks!

Sebastian,
Rod is probably off-line right now so if I may I'll answer your
questions.

By default Project creates a dynamic master when individual projects are
inserted into a new blank project (Insert/Project). That means that the
individual subprojects, as they are called, are linked to the new master
but are not actually a part of it. During the manual process, (or VBA
using the ConsolidateProjects Method), of creating a master, there is an
option to "link to project", (manual creation), or "AttachToSources",
(VBA creation), that allows the user to create a static master. A static
master file is a whole separate file made up of all the subprojects. As
Rod indicated, a static consolidation combines resource information from
all subprojects.

With regard to creating a resource pool, it has nothing to do with
Project standard, Project professional or Project server. A resource
pool file is nothing more than a blank dynamic master that contains
resources only (i.e. no tasks). Other files can then use the resources
from the pool by going to Tools/Resource Sharing/Share Resources and
opting to use resources from the resource pool file. You can read more
about resource pools in the Project Help file.

Hopefully this has clarified some things for you. If not, post back and
we'll try again.

John
Project MVP

 

[Rod Gill]

I always recommend creating weekly consolidations with no link as that
avoids the corruptions problems associated with having linked files (one
link per file for a master project and one per file for the resource pool.
Any renaming, over-writing or moving rolls the dice of corruption and sooner
or later one or more files will corrupt, so be very careful!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com