Resource Pool Links

[Cheryl]

How can I export the file and path information for all the project files that
are tied to a resource Pool?

 

[Brian K - Project MVP]

How can I export the file and path information for all the project files
that
are tied to a resource Pool?

you can't. The link is FROM the sharer file and it is held there. The pool
does not know about the files that use it.

Sorry

 

[Cheryl]

HUM....I'm not sure that I understand that. I can open the pool and go to
Share Resources. There it will display a path and file name, therefore one
would think that the information has to be available.

Anyone else with an opinion?

 

[Brian K - Project MVP]

HUM....I'm not sure that I understand that. I can open the pool and go to
Share Resources. There it will display a path and file name, therefore one
would think that the information has to be available.

Anyone else with an opinion?

Never answer questions on an empty stomach!

Obviously, as you point out, you can see this in the Resource Usage View
if you insert the Project field. Here is some simple VBA code that gives
you a hook to the list.

Sub ExportPoolLinks()
Dim A As Assignment
Dim R As Resource
For Each R In ActiveProject.Resources
For Each A In R.Assignments
Debug.Print A.Project
Next A
Next R
End Sub

 

[Cheryl]

Thanks Brian. I will give this a shot.

Never answer questions on an empty stomach!

Obviously, as you point out, you can see this in the Resource Usage View
if you insert the Project field. Here is some simple VBA code that gives
you a hook to the list.

Sub ExportPoolLinks()
Dim A As Assignment
Dim R As Resource
For Each R In ActiveProject.Resources
For Each A In R.Assignments
Debug.Print A.Project
Next A
Next R
End Sub