Resource Usage view

[sometimes i cringe]

I have a consolidated project with many subtasks linked into a main
project.

On the Gnatt Chart, the Task Name is always the file name that I have
assigned to the sub project (ie. 100 - Job). However, when I bring up
the Resource Usage view, the Project field is the full path of the sub
project (ie. C:\Files\100 - Job.mpp).

Is there any way to change that full path name in the Resource Usage to
just show the sub project file name? If not, this is a very annoying
feature of consolidated projects!

 

[John]

I have a consolidated project with many subtasks linked into a main
project.

On the Gnatt Chart, the Task Name is always the file name that I have
assigned to the sub project (ie. 100 - Job). However, when I bring up
the Resource Usage view, the Project field is the full path of the sub
project (ie. C:\Files\100 - Job.mpp).

Is there any way to change that full path name in the Resource Usage to
just show the sub project file name? If not, this is a very annoying
feature of consolidated projects!

Sometimes,
Let me guess, are the subprojects and the master in different
directories and/or folders? If everything is in the same directory and
folder, (that's the recommended construct), you shouldn't see the full
path in the Project field on the assignment rows of the Resource Usage
view.

If you really need to have the files in different folders, you can still
set up a spare field to show just the project name without the full
path. However, because you are talking about assignment rows in the
Resource Usage view, you cannot use a formula in a custom field
(formulas are not available for assignment rows). Instead you will need
to use VBA to parse out the filename from the full path and then write
that data into the spare assignment text field. If you want help setting
up that macro, let us know.

John
Project MVP

 

[sometimes i cringe]

The subproject files are in other directories, yes...but, its still th
same when I have them in the same directory as the master list; th
full path name still appears...I tried last night before I poste
thinking this was the problem...

I figured VBA may be my only option here...I'm unable to view the cod
from Project though...its not an available menu item...is this
separate install?

thanks for your help

 

[John]

The subproject files are in other directories, yes...but, its still the
same when I have them in the same directory as the master list; the
full path name still appears...I tried last night before I posted
thinking this was the problem...

I figured VBA may be my only option here...I'm unable to view the code
from Project though...its not an available menu item...is this a
separate install?

thanks for your help

sometimes,
One thing that will mask the path is to have all subprojects open. Then
the Project field in the master will display only the subproject file
name. However, that may not be convenient in your case.

With regard to the VBA approach I don't understand your statement about
not being able to, "...view the code...". What code? VBA code only
exists if a macro was recorded or written. Do you perhaps mean the
Visual Basic Editor window, which can be accessed under Tools/Macro?

Project VBA is automatically installed with Project unless the user does
a custom install and specifically excludes VBA functionality. What
version of Project are you using? If you did perform a custom install,
you should be able to add VBA functionality by inserting your install
disk and picking up missing components. I don't remember what the actual
install window looks like but as I recall it will automatically
recognize that you have Project installed and alert you to any
uninstalled components, and ask if you want to add those.

John
Project MVP