*Technically* this will always be 1 step behind any saves you make.
For example: if you save the file as ABC.MPP then the Properties field will not be updated until the NEXT time you open the file.
But this is actually a good thing because you can rename the file on the disk and then open it. When you open the renamed file, that renamed filename is used to populate the Properties field.
Making the Project Summary Task is not the problem. I can create a template file with that option checked in the tools>options>view tab.
The difficult bit for me, is to have a method of forcing the Project Summary Task to automatically reflect the mpp project "filename".
If this isnt possible, perhaps I could customise a text field in the project plan to automatically place the mpp filename in line with all of the tasks down the project plan.
The reason Im trying to do this to manipulate the data out of a master project plan for reporting. Each child project would have a different filename against the task descriptions.
Hope this makes sense everyone. :)
Member for
18 years 3 months
Member for18 years3 months
Submitted by L.E.N. Lewis on Tue, 2009-03-24 10:13
Put a check mark in "Show project summary task" and youll see that its there.
For an existing project file:
File > Properties > Summary-tab > Title-field
Given that you have to type something in Excel to have the file name appear, the "new project file" approach is significantly more efficient to propagate the filename to the Project Summary Task and the "existing project file" is just 3 clicks away.
Member for
16 years 7 monthsRE: Filename into Project Summary Task
Thanks LEN Lewis...Ill give it a go.
Been very frustrated to see the option to save project 07 files as access databases.
Saving master projects in excel and reporting from that... this will help retaining filenames in the master file.
Member for
18 years 3 monthsRE: Filename into Project Summary Task
Add the following VBA to your project file:
Private Sub Project_Open(ByVal pj As Project)
ActiveProject.ProjectSummaryTask.Name = ActiveProject.Name
End Sub
*Technically* this will always be 1 step behind any saves you make.
For example: if you save the file as ABC.MPP then the Properties field will not be updated until the NEXT time you open the file.
But this is actually a good thing because you can rename the file on the disk and then open it. When you open the renamed file, that renamed filename is used to populate the Properties field.
Member for
16 years 7 monthsRE: Filename into Project Summary Task
Merci Alexandre.
Great idea...I just tried that but unfortunately the field becomes blank when I take the title out of the properties dialogue.
Im using MSP 2007 & have found that this functions a little differently to the previous versions... and not always in a good way.
Any ideas about a function to place the filename into an added column like the Text1 column?
Many thanks again for your help. :)
Member for
22 years 9 monthsRE: Filename into Project Summary Task
Sa,
just clear the "Project Title" field in the Properties dialog; MSP will then display the project file name instead of the project title
Alexandre
Member for
16 years 7 monthsRE: Filename into Project Summary Task
Thanks for getting back so fast LEN Lewis. :)
Sorry, I think you have missed my aim.
Making the Project Summary Task is not the problem. I can create a template file with that option checked in the tools>options>view tab.
The difficult bit for me, is to have a method of forcing the Project Summary Task to automatically reflect the mpp project "filename".
If this isnt possible, perhaps I could customise a text field in the project plan to automatically place the mpp filename in line with all of the tasks down the project plan.
The reason Im trying to do this to manipulate the data out of a master project plan for reporting. Each child project would have a different filename against the task descriptions.
Hope this makes sense everyone. :)
Member for
18 years 3 monthsRE: Filename into Project Summary Task
For a new project file:
File > New
create your file
File > Save
The next time you open your file:
Tools > Options > View-tab
Put a check mark in "Show project summary task" and youll see that its there.
For an existing project file:
File > Properties > Summary-tab > Title-field
Given that you have to type something in Excel to have the file name appear, the "new project file" approach is significantly more efficient to propagate the filename to the Project Summary Task and the "existing project file" is just 3 clicks away.