Get at Sharing Links from Shared Resource File via VBA?

[Rob Schneider]

Folks,

Seems like I should be able to figure this out, but so far it has
stumped me.

The situation is that we have a set of project files all sharing the
same rsource file. As time goes on, we need to prune the list of shared
links by breaking links.

While in the Shared Resource File, the "Shared Resources" dialogue box
displays those links, the problem is that the full path to those links
is displayed and since the path is too long to display in the dialogue
box we can't easily see the actual files that are linked. Further, the
dialogue box is not resizable to enlarge the view.

My idea was to write a small VBA macro to display the list of shared
links and, if easy, would even put a button to break that link on the
form we could create. Problem is I cannot find any objects or methods
in the Project 2007 documentation that gives access to this information.

Are there objects/methods that I've not yet spotted? Is there another
way to do this, e.g. display the full path of all the shared linked files?

thanks!

--rms

 

[Rod Gill]

Hi,

From memory, the only way to get a list of projects sharing the pool is to
investigate the Project property for each Assignment in the pool. To see how
to disconnect from a pool record a macro of you doing so manually.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Rob Schneider]

Hi,

From memory, the only way to get a list of projects sharing the pool is
to investigate the Project property for each Assignment in the pool. To
see how to disconnect from a pool record a macro of you doing so manually.

Rod,

Thanks. you have confirmed my suspicisions... will have to crack open
your VBA book and get coding!

--rms