Expose "Last Saved By" in Legend

[tommcbrny]

Hello,

Is there a way to show the "Last saved by" field in a print view in Project
(using Project Standard 2k3).

In my legend I show a version and the Last Saved Date, but Last saved by
(which appears in Properties->Statistics tab) is not a selection from the
pull down list. I've tried a few &[xxx] combinations but none of them
display the value I want.

Thanks,
Tom

 

[Jim Aksel]

You are limited in the legend to the fields shown in the drop down.
However, you can assign a formula that will help you....

First, the information you desire is contained in the Project Summary Level
Task. This is TaskID 0 and UniqueID 0... always. So, you can do
Tools/Options/View (tab) and select the "Show Project Summary Level Task" box.

Insert a field, such as Text30. In the ID 0 task, enter the last saved by
information into Text30. Then, show Text30 in your Legend.

There is another way as well. Use this line of code as a formula or Macro:
ActiveProject.Tasks.UniqueID(0).Text30 = ActiveProject.LastSavedBy

However, you need to place this line of code judiciously. If you place it
in a Macro that runs when the file opens you will get good information.
However, if Joe was the last save and John opens the file and then saves the
LastSavedBy is still "Joe" until you re-run the Macro.

So, try this. Make sure the Automatic Calculations is set to Automatic, not
manual.
In the Microsoft Project Objects place this code:

Private Sub Project_Calculate(ByVal pj As Project)
pj.Tasks.UniqueID(0).Text30 = pj.LastSavedBy
End Sub

This code executes each time the project calculates. You can change Text30
to anything desired.

See.... never let the software win.


--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[Jim Aksel]

One minor correction before my friend discover....
When I said:

However, if Joe was the last save and John opens the file and then saves the
LastSavedBy is still "Joe" until you re-run the Macro.

What I Really Meant to say was...

However, if Joe was the last save and John opens the file and then saves the
Text30 for Task 0 is still "Joe" until you re-run the Macro.

Anyway, I tested it and it works.

--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

You are limited in the legend to the fields shown in the drop down.
However, you can assign a formula that will help you....

First, the information you desire is contained in the Project Summary Level
Task. This is TaskID 0 and UniqueID 0... always. So, you can do
Tools/Options/View (tab) and select the "Show Project Summary Level Task" box.

Insert a field, such as Text30. In the ID 0 task, enter the last saved by
information into Text30. Then, show Text30 in your Legend.

There is another way as well. Use this line of code as a formula or Macro:
ActiveProject.Tasks.UniqueID(0).Text30 = ActiveProject.LastSavedBy

However, you need to place this line of code judiciously. If you place it
in a Macro that runs when the file opens you will get good information.
However, if Joe was the last save and John opens the file and then saves the
LastSavedBy is still "Joe" until you re-run the Macro.

So, try this. Make sure the Automatic Calculations is set to Automatic, not
manual.
In the Microsoft Project Objects place this code:

Private Sub Project_Calculate(ByVal pj As Project)
pj.Tasks.UniqueID(0).Text30 = pj.LastSavedBy
End Sub

This code executes each time the project calculates. You can change Text30
to anything desired.

See.... never let the software win.


--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

Hello,

Is there a way to show the "Last saved by" field in a print view in Project
(using Project Standard 2k3).

In my legend I show a version and the Last Saved Date, but Last saved by
(which appears in Properties->Statistics tab) is not a selection from the
pull down list. I've tried a few &[xxx] combinations but none of them
display the value I want.

Thanks,
Tom

 

[tommcbrny]

Hi Jim,

When trying the second option you mention and adding to the Global.MPT
project (since I want this to be available in all project files I create), I
receive a Run-time error '1101: The value is not valid.

I did not try the first option as I'm a little confused by it. When you say
"enter the last saved by information into Textxx", do you mean enter it in
this field manually?

Thanks for the help,

Tom

One minor correction before my friend discover....
When I said:

However, if Joe was the last save and John opens the file and then saves the
LastSavedBy is still "Joe" until you re-run the Macro.

What I Really Meant to say was...

However, if Joe was the last save and John opens the file and then saves the
Text30 for Task 0 is still "Joe" until you re-run the Macro.

Anyway, I tested it and it works.

--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

You are limited in the legend to the fields shown in the drop down.
However, you can assign a formula that will help you....

First, the information you desire is contained in the Project Summary Level
Task. This is TaskID 0 and UniqueID 0... always. So, you can do
Tools/Options/View (tab) and select the "Show Project Summary Level Task" box.

Insert a field, such as Text30. In the ID 0 task, enter the last saved by
information into Text30. Then, show Text30 in your Legend.

There is another way as well. Use this line of code as a formula or Macro:
ActiveProject.Tasks.UniqueID(0).Text30 = ActiveProject.LastSavedBy

However, you need to place this line of code judiciously. If you place it
in a Macro that runs when the file opens you will get good information.
However, if Joe was the last save and John opens the file and then saves the
LastSavedBy is still "Joe" until you re-run the Macro.

So, try this. Make sure the Automatic Calculations is set to Automatic, not
manual.
In the Microsoft Project Objects place this code:

Private Sub Project_Calculate(ByVal pj As Project)
pj.Tasks.UniqueID(0).Text30 = pj.LastSavedBy
End Sub

This code executes each time the project calculates. You can change Text30
to anything desired.

See.... never let the software win.


--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

Hello,

Is there a way to show the "Last saved by" field in a print view in Project
(using Project Standard 2k3).

In my legend I show a version and the Last Saved Date, but Last saved by
(which appears in Properties->Statistics tab) is not a selection from the
pull down list. I've tried a few &[xxx] combinations but none of them
display the value I want.

Thanks,
Tom

 

[Jim Aksel]

1. I did not test my solution on a project with no tasks. That could be a
problem. Try commenting out the code, then open a new project. See if that
helps. Also, make sure the summary task is visible although that should not
matter.

As another alternative, I gave you a method for "Calculate" ... there is
another method called "Change" you could put the code there instead.

Other than that, it would be a typo someplace.

2. On my first solution, yes -- I meant to hand type the information into
"Text30" of task ID 0. My second solution offers a way to have Project
calculate it for you.
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

Hi Jim,

When trying the second option you mention and adding to the Global.MPT
project (since I want this to be available in all project files I create), I
receive a Run-time error '1101: The value is not valid.

I did not try the first option as I'm a little confused by it. When you say
"enter the last saved by information into Textxx", do you mean enter it in
this field manually?

Thanks for the help,

Tom

One minor correction before my friend discover....
When I said:

However, if Joe was the last save and John opens the file and then saves the
LastSavedBy is still "Joe" until you re-run the Macro.

What I Really Meant to say was...

However, if Joe was the last save and John opens the file and then saves the
Text30 for Task 0 is still "Joe" until you re-run the Macro.

Anyway, I tested it and it works.

--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

You are limited in the legend to the fields shown in the drop down.
However, you can assign a formula that will help you....

First, the information you desire is contained in the Project Summary Level
Task. This is TaskID 0 and UniqueID 0... always. So, you can do
Tools/Options/View (tab) and select the "Show Project Summary Level Task" box.

Insert a field, such as Text30. In the ID 0 task, enter the last saved by
information into Text30. Then, show Text30 in your Legend.

There is another way as well. Use this line of code as a formula or Macro:
ActiveProject.Tasks.UniqueID(0).Text30 = ActiveProject.LastSavedBy

However, you need to place this line of code judiciously. If you place it
in a Macro that runs when the file opens you will get good information.
However, if Joe was the last save and John opens the file and then saves the
LastSavedBy is still "Joe" until you re-run the Macro.

So, try this. Make sure the Automatic Calculations is set to Automatic, not
manual.
In the Microsoft Project Objects place this code:

Private Sub Project_Calculate(ByVal pj As Project)
pj.Tasks.UniqueID(0).Text30 = pj.LastSavedBy
End Sub

This code executes each time the project calculates. You can change Text30
to anything desired.

See.... never let the software win.


--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project



:

Hello,

Is there a way to show the "Last saved by" field in a print view in Project
(using Project Standard 2k3).

In my legend I show a version and the Last Saved Date, but Last saved by
(which appears in Properties->Statistics tab) is not a selection from the
pull down list. I've tried a few &[xxx] combinations but none of them
display the value I want.

Thanks,
Tom