date file modified
'-----------------------------------------------------------------
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")
or
=DocProps ("last save time")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Matthew" wrote in message
ps.com...
Is there any way (header/footer or in a cell) to display the date the
workbook was modified? I know you can look up the modified date in
File/Properties, but don't know how to display that.
|