When last saved?

[ph8]

Is there a way to pull a timestamp from an excel spreadsheet for whe
that spreadsheet was last saved?

If not? Is there a way to have excel update a timestamp cell PRIOR t
every time the spreadsheet gets saved?

Or even a VBA macro which runs prior to a save?

Basicaly I need a way to reliably pull the time stamp from when
spreadsheet was last saved.

Any thoughts

 

[Guest]

Try this line...

MsgBox ThisWorkbook.BuiltinDocumentProperties("Last save time")

 

[ph8]

Perfect. Thanks Jim!

Now one more question, is there a way for an excel formula to return
the same result?

 

[Art H]

You could make a function out of Jim Thomlinson's code and call the
function in a cell.
Function strSaveDate() As String
If Len(ThisWorkbook.Path) <> 0 Then
strSaveDate = ThisWorkbook.BuiltinDocumentProperties("Last save
time")
Else
strSaveDate = "Not saved"
End If
End Function
A1 = "=strSaveDate()"

The path test is used to determine the file exists--I'm sure there's a
better way.