Removing a Work Resource at one shot from all projects

B

BBA

Is there a way by which I can remove/replace at one shot a work resource from
all of the projects in which he/she has been assigned tasks?
 
J

Jim Aksel

If the resource is removed, just delete it. It goes away everywhere.
If you want to substitute a new resource by removing "Old Resource" then it
would be easiest to rekey the new information over the old information (Sally
is now called Kevin at a new rate).

The hard part is if you want to replace "Exisiting Resource7" with "Existing
Resource26." I was thinking about writing a macro to do that myself, we
ended up doing it by hand yesterday since it was only 60 tasks and 5
resources.

It looks like you would want to loop through each task in each subproject.
Once on a task, you would need to loop through each resource assigned to the
task. Then, you'd ask "If the resource ID for this resource is 7, then
change it to 26."

If you had multiple replacements to make (7 is replaced by 26, 11 is
replaced by 4, ...) it could be done with a Select Case statement in the
code.

__
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project
 
J

Jose Zayas

Try by creating a Master Project of the projects in Question. Then you might
be able to replace the resource in all the projects. By replacing the
resource in this project.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top