Prev: task hierarchy in My tasks
Next: How do I change the project calander from 5 day to 7 day week?
From: sometimes i cringe on 1 May 2008 18:42

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 i cringe
------------------------------------------------------------------------
sometimes i cringe's Profile: http://forums.techarena.in/member.php?userid=47919
View this thread: http://forums.techarena.in/showthread.php?t=960351

http://forums.techarena.in

From: John on 1 May 2008 22:23
In article <sometimes.i.cringe.38r8jf(a)DoNotSpam.com>,
sometimes i cringe <sometimes.i.cringe.38r8jf(a)DoNotSpam.com> wrote:

> 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
From: sometimes i cringe on 2 May 2008 07:07

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

John;3707014 Wrote:
> In article <sometimes.i.cringe.38r8jf(a)DoNotSpam.com>,
> sometimes i cringe <sometimes.i.cringe.38r8jf(a)DoNotSpam.com> wrote:
>
> > 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
------------------------------------------------------------------------
sometimes i cringe's Profile: http://forums.techarena.in/member.php?userid=47919
View this thread: http://forums.techarena.in/showthread.php?t=960351

http://forums.techarena.in

From: John on 2 May 2008 11:01
In article <sometimes.i.cringe.38s5vd(a)DoNotSpam.com>,
sometimes i cringe <sometimes.i.cringe.38s5vd(a)DoNotSpam.com> wrote:

> 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
>
> John;3707014 Wrote:
> > In article <sometimes.i.cringe.38r8jf(a)DoNotSpam.com>,
> > sometimes i cringe <sometimes.i.cringe.38r8jf(a)DoNotSpam.com> wrote:
> >
> > > 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
 | 
Pages: 1
Prev: task hierarchy in My tasks
Next: How do I change the project calander from 5 day to 7 day week?