Cost rate table

[Rod Gill]

Hi,

Cost rates belong to assignments, not tasks, so:
View, Resource or Task Usage
Insert the Cost Rate Table column
Enter E as the rate for the first assignment then fill down.

 

[alexander.barvinsky@]

Greetings,
how to change "in one click" cost rate table for resources from default A to
E for example in all project tasks?
Thanks
Alerxander Barvinsky
pm4pm.org

 

[Ed Hanna]

Alexandar,

Here's a simple VBA macro that should give you the "in one click" change of
rates that you seek. Put an icon on the toolbar to execute the macro. A
real VBA expert might tweak this a little to make it more elegant--but this
should work. As written, it changes the cost rate table to "E". Just
substitute another number (0-4) to choose a different rate table (A-E).

Public Sub ChangeRate()
Dim n As Integer
Dim T As Task
For Each T in ActiveProject.Tasks
For n = 1 To T.Resources.Count
T.Assignments(n).CostRateTable = 4
Next
Next
End Sub

Ed

Edward M. Hanna, PMP
EPM Principal
Immedient Business Solutions from INS

 

[Alexander Barvinsky]

Great idea! Thanks.
I'm never used before VBA. How to add in this macro form for select cost rate
table before executing macro?

Thank's and respect!!

Alexandar,

Here's a simple VBA macro that should give you the "in one click" change of
rates that you seek. Put an icon on the toolbar to execute the macro. A
real VBA expert might tweak this a little to make it more elegant--but this
should work. As written, it changes the cost rate table to "E". Just
substitute another number (0-4) to choose a different rate table (A-E).

Public Sub ChangeRate()
Dim n As Integer
Dim T As Task
For Each T in ActiveProject.Tasks
For n = 1 To T.Resources.Count
T.Assignments(n).CostRateTable = 4
Next
Next
End Sub

Ed

Edward M. Hanna, PMP
EPM Principal
Immedient Business Solutions from INS

Alerxander Barvinsky
pm4pm.org

 

[Alexander Barvinsky]

I did it. With form, where user choosing Cost Rate Table.
But I don't understood how to add macro as icon on the toolbar.

Alexandar,

Here's a simple VBA macro that should give you the "in one click" change of
rates that you seek. Put an icon on the toolbar to execute the macro. A
real VBA expert might tweak this a little to make it more elegant--but this
should work. As written, it changes the cost rate table to "E". Just
substitute another number (0-4) to choose a different rate table (A-E).

Public Sub ChangeRate()
Dim n As Integer
Dim T As Task
For Each T in ActiveProject.Tasks
For n = 1 To T.Resources.Count
T.Assignments(n).CostRateTable = 4
Next
Next
End Sub

Ed

Edward M. Hanna, PMP
EPM Principal
Immedient Business Solutions from INS

Alerxander Barvinsky
pm4pm.org

 

[Mike Glen]

Hi Alexander,

I have explained this fully in my series on Microsoft Project in the
TechTrax ezine, particularly #16 - Macros, at this site:
http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the article before leaving the site,
Thanks.)

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

 

[Mike Glen]

Sorry, Alexander, I don't have the server version and so can't answer
definitively.


Mike Glen
Project MVP

 

[Gary L. Chefetz [MVP]]

Alexander:

That warning dialog is controlled by the Macro security setting in Project.

 

[Alexander Barvinsky]

On Wed, 10 Aug 2005 17:24:22 +0100, "Mike Glen" <glenATmvps.org> wrote:


My respect.
Great.
Can you answer another one question: how to export my macro in the
ent.global? After adding it with tools->organizer then I'm opening MS Project
Professional I see warning:

"<<>\global20050811121027\global20050811121027" contains macros.

Macros may ..... blah-blah-blah"

I don't want to change security level. How to add macro to the trusted list
or smth similar?

I have explained this fully in my series on Microsoft Project in the
TechTrax ezine, particularly #16 - Macros, at this site:
http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the article before leaving the site,
Thanks.)

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

Alerxander Barvinsky
pm4pm.org

 

[Gary L. Chefetz [MVP]]

Alexander:

Inasmuch as this is a PROJECT option, how do you propose to control this
externally to the application?

 

[Alexander Barvinsky]

Thank's, but I know it. My answer is how to add macro as trusted to the
ent.resource global? Or I can't?

That warning dialog is controlled by the Macro security setting in Project.

Alerxander Barvinsky
pm4pm.org

 

[Gary L. Chefetz [MVP]]

Alexander:

Have you tried reading the help project help files on adding digital
signatures to macros? The instructions are fairly robust.

 

[Alexander Barvinsky]

All VBA macro have signatures. I think, what I can add "trusted" signature to
the macro.
Do you solve similar problem and you know what there is no solution?

Inasmuch as this is a PROJECT option, how do you propose to control this
externally to the application?

Alerxander Barvinsky
pm4pm.org

 

[Alexander Barvinsky]

I don't want to distribute my macro and buy certificate in VerySign. All what
I need - add it to the ent.global and suppres warning about macro in global
without changing in security settings. Is it clear?

Have you tried reading the help project help files on adding digital
signatures to macros? The instructions are fairly robust.

Alerxander Barvinsky
pm4pm.org