Display full folder/path for project in project column in resource

[MarkP]

Facts:
Project 2007
Resource Usage view
Resource Pool
5+ files as sharere projects

Problem:
I want to see the full folder/path name for all projects in the Resource
Usage view


This is what I see:

ID Task Name Project
--- -------------- ---------
1 Task One ProjectXYX
2 Task Two ProjectXYX

---

1 Task One NewProjectABC


This is what I WANT to see:

This is what I see:

ID Task Name Project
--- -------------- ---------
1 Task One C:\\My Documents\PMO\Projects\ProjectXYX
2 Task Two C:\\My Documents\PMO\Projects\ProjectXYX

---

1 Task One M:\\NetworkShare\PMO\Project\TeamABC\NewProjectABC



Is there a seeting somewhere that tell MS Project I want more detail file
info ?

Any other suggestions?

Thanks,
Mark

PS: Sorry if this was posted twice. I was having browser issues.

 

[Rob Schneider]

If the tasks are in linked subprojects, then display on the view the
field "sub project file".

I quickly looked at all the available task fieldsand there is not one I
can spot that is the the name of the file. That sort of make sense
since the file name is not really a task property. However, what you
could do is write a small VBA function that get's the file name from the
object model, and return that value to one of the custom fields, and
display that field on the view.

--rms

www.rmschneider.com

 

[JulieS]

Hello Mark,

If you open the Resource pool file with option number 2 - "Open the
pool read-write....." but do not open the sharer files, the full
path should show in the Project field in the Resource Usage view.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[MarkP]

Rob,

Thanks for the repy, but...

There is no "sub project file" column in the Resoource Usage view.

I'm in the Resource Pool, so I neen to look in that view.

The "sub project file" column in the Task Usage view, but unless I'm doing
something wrong, nothing shows.

The VBA idea looks good. I tried browsing the Developer forum and found
this: ActiveProject.FullName

THANKS for your help.
-Mark

 

[MarkP]

Julie,

I did notice that as well.

But I was looking for a guaranteed way to have the full file name available.

The "ActiveProject.FullName " seems to to the trick.

Thanks for jumping in.

- Mark

 

[Rob Schneider]

Yes. You are quite right. My head was on the task view. In any event,
the file name is not a property of the resource, so I guess it makes
sense that it's not there. But I suspect you can do it the VBA way. Or
at least try.

--rms

www.rmschneider.com

 

[JulieS]

You're welcome Mark.

Julie,

I did notice that as well.

But I was looking for a guaranteed way to have the full file name
available.

The "ActiveProject.FullName " seems to to the trick.

Thanks for jumping in.

- Mark