Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mercerbear

    Import Resource information into Effective Date and Standard Rate ??

    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...
  2. mercerbear

    Import Resource information into Effective Date and Standard Rate ??

    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...
  3. mercerbear

    Import Resource information into Effective Date and Standard Rate ??

    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...
  4. mercerbear

    Import Resource information into Effective Date and Standard Rate ??

    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...
  5. mercerbear

    Import Resource information into Effective Date and Standard Rate ??

    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...
  6. mercerbear

    Import Resource information into Effective Date and Standard Rate ??

    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...

Part and Inventory Search

Back
Top