Date & Time file was last saved

M

M.Siler

Is there away to display in a cell the date & time the file was last saved?
I know you can do this in word but is it possible in Excel 2002?
 
B

Bob Phillips

Here is an UDF

Function DocProps(prop As String)
application.volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function

Now you can use the following formula in one of your cells:
=DocProps("Last save time")

Obviously, the file has to have been saved.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top