Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I show last date file saved?
I want a cell to show the last saved file date and not change every time I
open the file except when it is saved. |
#2
|
|||
|
|||
Try a UDF like
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 can be used like so =DocProps("Last save time") -- HTH RP (remove nothere from the email address if mailing direct) "Pete" wrote in message ... I want a cell to show the last saved file date and not change every time I open the file except when it is saved. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert the date the file was saved in the MS Excel foote. | Excel Discussion (Misc queries) | |||
Help... File Not Saved | Excel Discussion (Misc queries) | |||
How do I show the last saved date in an Excel worksheet? | Excel Worksheet Functions | |||
store file saved date in cell | Excel Worksheet Functions | |||
Show a date based on today | Excel Worksheet Functions |