Create New Resource with Cost Rate Tables

[D. Fuhrman]

Hi,

I'm new at VBA for Project 2003 (Duh!)

If someone could provide an example of a macro to create one or more
resources and apply values to the cost rate tables, I'd be very grateful.

I've tried various examples from the SDK but I'm getting errors such as
"Expected: end of statement" with little explanation as to what went wrong.

Many thanks in advance.

~ Don

 

[Ed Morrison]

You can use the macro recorder to find out how to do a lot of things. Just
start recording a macro (Tools, Macro, Record New Macro...) and do manually
what you want code for.

For cost rate tables, search in the VBA help for payrate. It gives a good
example.

 

[D. Fuhrman]

Hi,

I've done the things you suggest (below).

1. The macro recorder does not record events on the cost rate tables.

2. I used various examples WRT PayRate, but I get errors, as I described in
my original post (Expected: end of statement").

~ Don

 

[D. Fuhrman]

Hi again,

Since I just installed SP2 last night (after my initial posting), I thought
I'd try the macro recorder again on the cost rate table. Here's what it
recorded:

------------------ cut here ---------------------------
Sub TestMRecorder()
' Macro TestMRecorder
' Macro Recorded Thu 10/6/05 by Don Fuhrman.
SelectRow Row:=0
End Sub
------------------ cut here ---------------------------

As you can see, the additions to the cost rate table (Effective Date, Std.
Rate, Per Use Cost) were not recorded. I cannot say why.

~ ???

 

[Ed Morrison]

What is your code? "Expected End of Statement" is usually a simple
syntactical error such as missing a closing parenthesis.

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com

 

[D. Fuhrman]

Hi,

I figured it out; I didn't need the parentheses, as I thought.

I was mis-interpreting the "help" in the Visual Basic Editor.

~ Don