insert savedate field into excel

[cpugh]

Is there any way to show the save date of the excel document in the same way that ms word does when you insert the savedate field?

 

[XL-Dennis]

cpugh,

Yes, but it require a User Defined Function (UDF).

<pre>
Public Function LastSaved() As String
Application.Volatile (True)
LastSaved = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
End Function
</pre>

Mail back if You need help with creating it

HTH,
Dennis

 

[cpugh]

Thanks - that's perfect! I set it up to run each time the spreadsheet is opened, and it pastes LastSaved into a cell in one of the worksheets )

 

[Juan Pablo González]

Dennis, why did you make it Volatile ?

That function *shouldn't* change THAT often ! :wink:

 

[XL-Dennis]

ADVERTISEMENT

On 2002-08-26 17:05, Juan Pablo G. wrote:
Dennis, why did you make it Volatile ?

That function *shouldn't* change THAT often ! :wink:

LOL :wink:
While testing it out I saved it a lot and it didn´t update so I placed the Volatile-function into it....

Kind regards,
Dennis
_________________
"Windows was not able to find any keyboard. Press F1-button to try again or F2-button for cancel."
This message was edited by XL-Dennis on 2002-08-27 00:41

 

[ai18ma]

Hi Denis,

Thanks for the tip. However, somehow it works differently with me! Here's what I did:
1. Opened the VBA editor (Press Alt+F11)
2. Inserted a new module (Insert > Module)
3. Copy/Pasted the user defined function LastSaved as shown here.
4. Left the VBA editor (Press Alt+Q)

At first, it displayed: 06.06.2007 and a time value. I then saved, closed and re-opened Excel. The function seemed to work. Now, it is stuck at this other value: 30.10.2007 12:55:22! And no matter what I do, the same value is shown. What have I done wrong?

I am using English Excel on a German machine.

Thanks

 

[MBurgin]

ADVERTISEMENT

That's really useful, but is it possible just to return the date rather than the date and time?

Thanks,

Mark

 

[ahmetgns]

That's really useful, but is it possible just to return the date rather than the date and time?

Thanks,

Mark

Try this;

LEFT(LastSave();10)

 

[takoisam]

Try this;

LEFT(LastSave();10)

Another option to displaying only the date is:

=TEXT(LastSaved(), "m/d/YYYY")

You can replace the m/d/YYYY with whatever your preferred date formatting is.

Sorry for bumping such an old thread.