Custom Fields to Subprojects

[Terry]

I have a master file where I have linked numerous subprojects to. I
have created a custom field that compares the baseline finish date with
the finish date. I would like this custom field to filter down into
the subprojects. I have been copying this custom field into every
subproject...but everytime I modify this field, I have to re-copy it to
every subproject. It's getting tedious.

is there a better way to do this? Is there someway to make the custom
field in the master file somehow automatically filter into the
subprojects?

Thanks for the help!

 

[Terry]

hm...I was afraid that the answer wasn't going to be that simple.
Unfortunately, I don't know much about utilizing VBA code in Project.

Thanks for the code though. I can at least play around with it and see
if I can get it to work.

Thanks!

 

[John]

I have a master file where I have linked numerous subprojects to. I
have created a custom field that compares the baseline finish date with
the finish date. I would like this custom field to filter down into
the subprojects. I have been copying this custom field into every
subproject...but everytime I modify this field, I have to re-copy it to
every subproject. It's getting tedious.

is there a better way to do this? Is there someway to make the custom
field in the master file somehow automatically filter into the
subprojects?

Thanks for the help!

Terry,
The problem with spare (custom) fields and several others is that they
belong to the master file, not to the subprojects. Let me explain. When
you build a master with inserted subprojects, the subproject files
themselves do not become part of the master. Rather, the subproject
files are represented by pointers in the master. The result is the
following: Let's say Text1 in the master has been customized to
concatenate the WBS and Name fields. For each task line that is actually
part of the master the concatenated value will show up, but it will not
show up in Text1 on any subproject task line.

What you want can be done but I'm not sure there is any way to do it
with simple customized fields. Most likely VBA will be required. With
some simple VBA code, whatever values you need can be "written" into a
spare field for both the master and all subprojects. The following code
will perform the function described in the example above:

Sub CustomMaster()
OutlineShowTasks expandinsertedprojects:=True
For Each t In ActiveProject.Tasks
If Not t is Nothing Then
t.Text25 = t.WBS & t.Name
End If
Next t
End Sub

Keep in mind that to preserve the values in the spare field, both the
master and all subproject will need to be saved

Hope this helps.
John
Project MVP

 

[John]

hm...I was afraid that the answer wasn't going to be that simple.
Unfortunately, I don't know much about utilizing VBA code in Project.

Thanks for the code though. I can at least play around with it and see
if I can get it to work.

Thanks!

Terry,
I "preach" the use of VBA a lot on this newsgroup because I hate to see
users struggle with something that can be accomplish very simply with a
little VBA code. You'd be amazed at what can be done with VBA.

John