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

a spreadsheet, similar to the FP feature?

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)


"Scuda" <Scuda@discussions.microsoft.com> wrote in message
news:4E0B144E-9D9F-45FE-A637-FA1E6C27C4D5@microsoft.com...
> a spreadsheet, similar to the FP feature?