VBA, Changing a resource throughout a project

Changing a resource throughout a project

Author	Message
David Stumble #1 / 4	Changing a resource throughout a project G'day, I would like to write code (or do it without code if possible) to change a resource to another resource. Eg: Many tasks have the resource "FitABB", but I want them to use another existing resource, "Fit". I want to retain "FitABB" in the resource pool, but want any task using "FitABB" to now use "Fit" instead. Any help would be greatly appreciated. I'm sure I'm missing something simple!! Thanks, Dave.
Tue, 30 Nov 2004 07:19:48 GMT

Mike Gle #2 / 4	Changing a resource throughout a project Hi David, Welcome to the Microsoft Project newsgroup :-) Have you tried Edit/Replace? FAQs, companion products and other useful Project information can be seen at this web address: <http://www.mvps.org/project/> Hope this helps - please let us know how you get on:-) Mike Glen MS Project MVP Quote: > G'day, > I would like to write code (or do it without code if > possible) to change a resource to another resource. > Eg: Many tasks have the resource "FitABB", but I want them > to use another existing resource, "Fit". I want to > retain "FitABB" in the resource pool, but want any task > using "FitABB" to now use "Fit" instead. > Any help would be greatly appreciated. I'm sure I'm > missing something simple!! > Thanks, > Dave.
Wed, 01 Dec 2004 04:58:35 GMT

Rod Gil #3 / 4	Changing a resource throughout a project Hi, In project select a task or tasks with the FitAbb resource assigned. press Alt+F10 to display the Assign Resource dialog. Click Replace Select the new Fit resource and click OK. This will replace the first resource with the second. To do this in VBA, try recording a macro of you replacing the resource and see what gets created. -- Visit www.mvps.org/project/ for the Project MVP's FAQ and third party add-ons Rod Gill Microsoft Project MVP Visit www.projectlearning.com for customized Project and Office VBA macros and Project companion software Quote: > G'day, > I would like to write code (or do it without code if > possible) to change a resource to another resource. > Eg: Many tasks have the resource "FitABB", but I want them > to use another existing resource, "Fit". I want to > retain "FitABB" in the resource pool, but want any task > using "FitABB" to now use "Fit" instead. > Any help would be greatly appreciated. I'm sure I'm > missing something simple!! > Thanks, > Dave.
Wed, 01 Dec 2004 09:47:16 GMT

David Stumble #4 / 4	Changing a resource throughout a project Thanks Gents. I actually thought of Edit Replace shortly after I posted my message. However, Rod's suggestion is handy. Thanks, David Stumbles Quote: >-----Original Message----- >Hi David, >Welcome to the Microsoft Project newsgroup :-) >Have you tried Edit/Replace? >FAQs, companion products and other useful Project information can be seen at Quote: >this web address: <http://www.mvps.org/project/> >Hope this helps - please let us know how you get on:-) >Mike Glen >MS Project MVP message >> G'day, >> I would like to write code (or do it without code if >> possible) to change a resource to another resource. >> Eg: Many tasks have the resource "FitABB", but I want them >> to use another existing resource, "Fit". I want to >> retain "FitABB" in the resource pool, but want any task >> using "FitABB" to now use "Fit" instead. >> Any help would be greatly appreciated. I'm sure I'm >> missing something simple!! >> Thanks, >> Dave. >.
Sun, 05 Dec 2004 07:26:36 GMT

Page 1 of 1

[ 4 post ]