List of files linked to pool

[Juan Espinel]

Hi,

I´m using MS-Project 2000 and I need to obtain the list of
files linked to the resource pool. I´ve tried with
ResourceSharingPool* methods but there's no way.

Any ideas?

Thank you.

 

[Rod Gill]

HI,

Try inserting the Project field in the resource pool and see what you get.

activeproject.Resources(1).Project may help as well

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/
Hi,

I´m using MS-Project 2000 and I need to obtain the list of
files linked to the resource pool. I´ve tried with
ResourceSharingPool* methods but there's no way.

Any ideas?

Thank you.

 

[Juan Espinel]

Hello Rod.

I've tried this but I obtain the resource pool file
name. I'm using now a workaround seeing which tasks are
assigned to each resource. I can get the name of the
project for each task but this is tedious, take in account
that I have about 200 projects linked to the resource
pool. My idea is to check if the list of projects linked
to the resource pool is correct. Sometimes unlinking the
project from the pool doesn´t work fine and I need to know
which projects are OK and which no.

Thank you,
Juan

 

[Jan De Messemaeker]

Hi JUan,

It's been some time since I did it, so I don't fully remember each object,
but what I did was open the pool "Pool and Sharers", find which was the
master file created, and then with a for each subproject... you get what you
need.
HTH

Jan De Messemaeker
Project MVP
Hello Rod.

I've tried this but I obtain the resource pool file
name. I'm using now a workaround seeing which tasks are
assigned to each resource. I can get the name of the
project for each task but this is tedious, take in account
that I have about 200 projects linked to the resource
pool. My idea is to check if the list of projects linked
to the resource pool is correct. Sometimes unlinking the
project from the pool doesn´t work fine and I need to know
which projects are OK and which no.

Thank you,
Juan

 

[Juan Espinel]

-----Original Message-----
Hi JUan,

It's been some time since I did it, so I don't fully remember each object,
but what I did was open the pool "Pool and Sharers", find which was the
master file created, and then with a for each subproject... you get what you
need.
HTH

Jan De Messemaeker
Project MVP
Hello Rod.

I've tried this but I obtain the resource pool file
name. I'm using now a workaround seeing which tasks are
assigned to each resource. I can get the name of the
project for each task but this is tedious, take in account
that I have about 200 projects linked to the resource
pool. My idea is to check if the list of projects linked
to the resource pool is correct. Sometimes unlinking the
project from the pool doesn´t work fine and I need to know
which projects are OK and which no.

Thank you,
Juan



.

 

[Juan Espinel]

Hi Jan.
I'll work with that idea. Thank you.
Juan