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

B

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto-Insert Last Date Edited 5
want to track time while paste value in multiple column of same roe 1
I need Help with a date calculator 0
Date function to record changes within a row 2
Automatically pu date when cell is edited 3
11 months and 1 day from a given date 6
Any formula to insert last document saved date ? 1
Help with XDATE function add-in 3

Top