We are on the same page now.
In order to get project to update a resource's standard and overtime rates on a future effective date, you have to double click on a resource, go to the cost tab and manually enter those three fields. I would like to bypass this step and use a macro to...
Running the code didn't produce values for effective date, standard rate or overtime rate in the Resource Cost tab of Resources which is what I was hoping to achieve originally. I changed my field headers in Resource View to mirror the names I saw in your code hoping that would do the trick...
This is the code I ran. Verbatim what you posted. If there was something else I was supposed to do please let me know.
Sub PDQBach()
Dim res As Resource
Dim iCostRateTables As Integer
Dim iEntries As Integer
For Each res In ActiveProject.Resources
Debug.Print res.Name; " "
For...
PDQBach,
I pasted your code into a macro file and ran it but I have a feeling that the field names on my resource sheet did not quite match up to the names in the code. I went ahead and changed the column headers to Std Rate and OVT Rate but still didn't get an additional row in Resource Cost...
I tried to play around with the macro creater inside of project to no avail. The cells where you input effective date, standard rate and overtime rate are not copy/pastable. I am not a programmer so I am unsure of how it may be possible to create a vba macro for this task. Do you have any...
Hello,
I am new to MS Project (2007) and learning what I can out of text books and on the internet. I have been asked, among other things, to create a resource sheet in project that includes employee information for my company. I used the import wizard to import pertinent data from excel to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.