I am struggling to create a macro that will allow me to change the rate table used for a resource based on a value found in a custom field. What I am attempting to do something like the following pseudo code(please don't laugh as I have not programmed for more than a decade.)

For each row in the Resource Sheet

Switch

Case Text1 = "On Site" set the Cost Rate Table to A for the Resource

Case Text1 = "Client Offices" set Cost Rate Table to B for the Resource

Case Text1 = "Our Offices" set Cost Rate Table to C for the Resource

EndSwith

EndFor

Thanks in advance to tacking a look at this. I know this is so "third grade" for many of you. But, I am stuck and getting this to work means mucho brownie points with my boss.(smile)

- John

John,

You'll need to change the rate table on the Assignment - not on the resource. By default, Project uses rate table A for all assignments.

I am not a programmer but to explain the processes. You'd need to set the custom field at either the Resource or Task level. If at the Resource level, you'd need loop through each resource's assignments and set the cost rate table.

You might get some more in depth help at the Programming forum for Microsoft project.

See: http://social.technet.microsoft.com/...ct2010custprog