Access Resource Summary Row Field vie VBA

J

Johhny

I'm trying to access a resource summary row field (number20) from within a
macro. I'm using Group: Resource Group and the particular group I want is
"RU". Is it possible?

MS Project 2003 Professional
 
J

John

Johhny said:
I'm trying to access a resource summary row field (number20) from within a
macro. I'm using Group: Resource Group and the particular group I want is
"RU". Is it possible?

MS Project 2003 Professional

Johnny,
If by the "resource summary row" you mean the group header, that is not
a field and it is not accessible through VBA. It is for display purposes
only when the grouping function is active. The only way to replicate the
data on that row is to generate it separately in code. In other words,
select the tasks of that group in the same manner the grouping function
does and then sum up the desired data.

If you are talking about some other row, please elaborate. There is no
such thing as a "resource summary row" in Project.

John
Project MVP
 
J

John

Johhny said:
I was hoping there was an easier way. Thanks for the answer.

Johnny,
Well that's part of the fun when using VBA, sometimes you have to think
outside the bun, I mean box.

You're welcome and thanks for the feedback.

John
Project MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top