Anybody know why?

[John]

People,
In a private sub I am looping through the active project resources (see
following code snippet:

Private Sub SetBaseValues()
Dim tblltr as String
tblltr = "A"
For Each R In ActiveProject.Resources
If Not R Is Nothing Then
Set PR = R.CostRateTables(tblltr).PayRates
[rest of loop]
Next R

I get a runtime error 1004, "an unexpected error occurred with this
method" when the code tries to execute the "Set PR = ..." line. If I
change the tblltr variable to an interger, or if I insert "A" or 1 in
place of tblltr in the Set statement, the code runs fine.

According to VBA help, the index for the CostRateTables collection can
be either an index number or cost rate table name. Does anyone know why
I get the error?

John

 

[JackD]

It would seem that the VBA has a bug here and that you should use an
integer.
Why is there a bug?

So much of Project is unknowable that it is capable of spawning its own
religion.

 

[John]

It would seem that the VBA has a bug here and that you should use an
integer.
Why is there a bug?

So much of Project is unknowable that it is capable of spawning its own
religion.

Jack,
I hate when that happens! Actually I suspected it was a bug and already
worked around it by using the integer value, but at least you confirmed
my suspicions.

Thanks
John

 

[JackD]

Jack,
I hate when that happens! Actually I suspected it was a bug and already
worked around it by using the integer value, but at least you confirmed
my suspicions.

Thanks
John

If you are willing to tithe I'll enlighten you as to further mysteries.

-Jack

 

[John]

Jack,
I hate when that happens! Actually I suspected it was a bug and already
worked around it by using the integer value, but at least you confirmed
my suspicions.

Thanks
John

If you are willing to tithe I'll enlighten you as to further mysteries.

-Jack[/QUOTE]

Jack,
You sound just like our church's finance committee. Our church is
currently going through the annual pledge drive.

Unfortunately I find it all too easy to uncover mysteries in Project.
Generally they generate a few hours of frustrating trail and error
effort but eventually I figure out a work-around. I've been doing that
for years.

John

 

[Brian K - Project MVP]

If you are willing to tithe I'll enlighten you as to further mysteries.

-Jack

Jack,
You sound just like our church's finance committee. Our church is
currently going through the annual pledge drive.

Unfortunately I find it all too easy to uncover mysteries in Project.
Generally they generate a few hours of frustrating trail and error
effort but eventually I figure out a work-around. I've been doing that
for years.

John[/QUOTE]

If you learn well then jack will let you touch the bagwans shoe!

 

[John]

If you learn well then jack will let you touch the bagwans shoe!

Brian,
I "don't know jack" - but I do know Jack.

Man has this thread degenerated.

John

 

[JackD]

Brian,
I "don't know jack" - but I do know Jack.

Man has this thread degenerated.

John

Oh, it could be a LOT worse. Just ask David Gage.

-Jack

 

[Gary L. Chefetz [MVP]]

Just *how* drunk did they get you, Jack?

 

[JackD]

See John, even Gary is capable of bringing it down another notch without
even breaking a sweat.

 

[Gary L. Chefetz [MVP]]

Moi? Hey, I wasn't among the MIA.

See John, even Gary is capable of bringing it down another notch without
even breaking a sweat.

 

[John]

Moi? Hey, I wasn't among the MIA.

guys,
I'm shouting down the hole, are you guys still in there?

Obviously we don't have enough to do.

John