Prev: Project Viewer
Next: MS Project 2003 File Size Growing
From: Alex on 9 Feb 2010 23:16
Hello,

Situation:
I'm using MS Project 2003. No Project Server. I have several (10+) subprojects linked to the Consolidated/Master project file. The structure is simple:

Subproject1
-- Design1
-- Develop1
-- Implement1
Subproject2
-- Design2
-- Develop2
-- Implement2
etc.

Each task has additional text custom fields (Text1 - Status, Text2 - Issues, etc.). The information in these fields is supposed to be entered by project managers of the subprojects, and should be available in the master file. Everything works fine at the level of individual tasks (Design, Develop, etc.). When data is entered in the text fields of the individual tasks from the subproject files, it can be seen in the individual tasks of the master file. Same works in the opposite direction - updates from the master file propagate to the subprojects.

Problem:
Text custom fields of the Summary Tasks of the Master Project (i.e. subproject1, subproject2, etc.) do not get updates when text fields of the summary tasks of the subprojects are changed. These updates are necessary because information from these cells of the master project summary tasks will be exported into Excel for further processing/reporting.

Question:
Is there a way to link the text custom fields of the summary tasks (top-level) of the subprojects to the summary tasks of the master file?

If that?s impossible, maybe another option. In the subproject files, updates will be entered in the text fields of the first individual tasks under the summary tasks. These updates are available in the master file. Maybe there?s a macro that could be applied to the master file and perform something like that:
- search for the next summary task (not indented)
- go to the individual task immediately following the summary task
- copy info in the text field of the individual task
- paste info in the text field of the summary task
- continue to the next summary task.

Thanks.
Alex


Submitted via EggHeadCafe - Software Developer Portal of Choice
Sending SMTP email from within BizTalk Orchestration
http://www.eggheadcafe.com/tutorials/aspnet/9dd0f346-baf9-4674-a50f-1716445b26bc/sending-smtp-email-from-w.aspx
From: Rod Gill on 9 Feb 2010 23:34
Unfortunately, Project does not update custom fields for sub-projects and
Master files. A VBA macro is your only solution, but it's a fairly simple
one.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com




"Alex Bot" wrote in message news:201029231640alexei777(a)yahoo.com...
> Hello,
>
> Situation:
> I'm using MS Project 2003. No Project Server. I have several (10+)
> subprojects linked to the Consolidated/Master project file. The structure
> is simple:
>
> Subproject1
> -- Design1
> -- Develop1
> -- Implement1
> Subproject2
> -- Design2
> -- Develop2
> -- Implement2
> etc.
>
> Each task has additional text custom fields (Text1 - Status, Text2 -
> Issues, etc.). The information in these fields is supposed to be entered
> by project managers of the subprojects, and should be available in the
> master file. Everything works fine at the level of individual tasks
> (Design, Develop, etc.). When data is entered in the text fields of the
> individual tasks from the subproject files, it can be seen in the
> individual tasks of the master file. Same works in the opposite
> direction - updates from the master file propagate to the subprojects.
>
> Problem:
> Text custom fields of the Summary Tasks of the Master Project (i.e.
> subproject1, subproject2, etc.) do not get updates when text fields of the
> summary tasks of the subprojects are changed. These updates are necessary
> because information from these cells of the master project summary tasks
> will be exported into Excel for further processing/reporting.
>
> Question:
> Is there a way to link the text custom fields of the summary tasks
> (top-level) of the subprojects to the summary tasks of the master file?
>
> If that?s impossible, maybe another option. In the subproject files,
> updates will be entered in the text fields of the first individual tasks
> under the summary tasks. These updates are available in the master file.
> Maybe there?s a macro that could be applied to the master file and perform
> something like that:
> - search for the next summary task (not indented)
> - go to the individual task immediately following the summary task
> - copy info in the text field of the individual task
> - paste info in the text field of the summary task
> - continue to the next summary task.
>
> Thanks.
> Alex
>
>
> Submitted via EggHeadCafe - Software Developer Portal of Choice
> Sending SMTP email from within BizTalk Orchestration
> http://www.eggheadcafe.com/tutorials/aspnet/9dd0f346-baf9-4674-a50f-1716445b26bc/sending-smtp-email-from-w.aspx
>
> __________ Information from ESET Smart Security, version of virus
> signature database 4852 (20100209) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 4852 (20100209) __________

The message was checked by ESET Smart Security.

http://www.eset.com



 | 
Pages: 1
Prev: Project Viewer
Next: MS Project 2003 File Size Growing