List TeamMembers w/ VBA

[Chris]

Using VBA, how would I get a list of TeamMembers for the ActiveProject? I'm
not sure what method would be used to do this...

Any suggestions?

Thanks

 

[Rod Gill]

Do you mean the resources for the active project? if so:

Dim Res as Resource
For Each Res in ActiveProject.Resources
if not res is nothing then
Debug.print res.name
end if
Next


This code prints the name of all resources to the immediate window in the
VBE.
--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[Chris]

Thanks, that might be what I was looking for. I think I'm misunderstanding
the terms Project uses.

After you Build Team but before you assign the team members (resources?) to
any tasks - that's what I was trying to list.

I'll play around with that code to see if it's what I'm looking for.

Thanks for your help!

BTW - I'm planning on picking up your book!

 

[Rod Gill]

Thanks, happy coding!

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com