Resource pool

J

John Jensen

John,
I'm not sure that this information is readily available directly in the
sharer file but the following VBA code seems to work when run on the
sharer file.

Sub pool()
ResPoolLoc = ActiveProject.ResourcePoolName
End Sub

Hope this helps.
John
 
J

John

Hi John,
Thanks for your reply. I have copied and run the macro.
I either don't get any output or I can't find the output.
What am I doing wrong?
Thanks Again,
John
 
J

John

John,
Oops! I forgot to tell you to step through the macro instead of running
it. As you step through, you can look at the variables (in this case
there is just one) and see the value. However, to make it a little more
convenient, try the following:

Sub pool()
ResPoolLoc = ActiveProject.ResourcePoolName
MsgBox "Resource Pool path:" & Chr(13) & _
ResPoolLoc, vbInformation
End Sub

Sorry for the omission.

John
 

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