ExcelBanter - Excel 2003: can I insert a "last edited" date function?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel 2003: can I insert a "last edited" date function? (https://www.excelbanter.com/excel-worksheet-functions/32742-excel-2003-can-i-insert-%22last-edited%22-date-function.html)

KTK

Excel 2003: can I insert a "last edited" date function?

Can I insert a date function that will calculate the last edited or modified
date?

Bob Phillips

Try a UDF like

Function DocProps(prop As String)

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

err_value:
DocProps = CVErr(xlErrValue)
End Function

Called with

=DocProps("Last save time")

--
HTH

Bob Phillips

"KTK" wrote in message
...
Can I insert a date function that will calculate the last edited or
modified
date?

All times are GMT +1. The time now is 05:05 AM.