EXCEL - is there a way to insert "date modified" into

[Guest]

a spreadsheet, similar to the FP feature?

 

[Bob Phillips]

FP?

You will need a 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
and enter



in a cell such as
=DocProps ("last author") for the author
or
=DocProps ("last save time") for the last saved date, format the cell as
date



--

HTH

RP
(remove nothere from the email address if mailing direct)