Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-26-2014, 06:47 PM
JohnTurner JohnTurner is offline Cost Rate Table Macro Help Windows 7 32bit Cost Rate Table Macro Help Office 2007
Novice
Cost Rate Table Macro Help
 
Join Date: Jan 2014
Posts: 3
JohnTurner is on a distinguished road
Default Cost Rate Table Macro Help


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
Reply With Quote
  #2  
Old 01-27-2014, 07:53 AM
JulieS JulieS is offline Cost Rate Table Macro Help Windows 7 64bit Cost Rate Table Macro Help Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help: Very low response-rate! Jeff10 Office 6 12-17-2013 10:44 AM
Cost Rate Table Macro Help Need totoal cost despite project being in progress Sognamed Project 1 07-23-2013 06:06 AM
Cost Rate Table Macro Help Monthly Growth Rate Formula meggenm Excel 2 04-22-2013 09:21 PM
Cost Rate Table Macro Help Automatically updating currency exchange rate? Metamag Excel 2 09-07-2012 09:00 PM
How to rename cost column ketanco Project 3 06-15-2012 03:06 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft