Date File Last Saved

S

SMK

Lotus 123 has a @cell or @cellpointer function that will
display the date that a file was last saved. I have
searched for an equivalent in Excel but can't find one.
Does anyone know of a function to give me this info?
 
B

Bob Phillips

You can create a UDF like so

Function DocProps(prop As String)

On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties(prop)
Exit Function

err_value:
DocProps = CVErr(xlErrValue)
End Function



and can be used like so

=DocProps("Last save time")

--

HTH

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