Get at Sharing Links from Shared Resource File via VBA?


R

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
 
Ad

Advertisements

R

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
 
Ad

Advertisements

R

Rob Schneider

Rod said:
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
 

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