Last saved date into an excel cell
I would like to have the date that the spreadsheet was edited (last saved) in
an Excel cell. If I use the =now() this will get updated when the spreasheet is viewed. There is a variable as the date that the spreadsheet is saved can be view in an explorer window. |
Hi
Take a look at BuiltinDocumentProperties I think this will provide what you need, you merely need to chop out the required bits in a function (I havent tested this and I hope this is one of the "thread safe" (callable) functions from within a function in a spreadsheet. ttfn benm |
Hi
use the following UDF (only on workbook level): 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 =DOCPROPS("last save time") (format cell as date) "Steve J. Vaughan" wrote: I would like to have the date that the spreadsheet was edited (last saved) in an Excel cell. If I use the =now() this will get updated when the spreasheet is viewed. There is a variable as the date that the spreadsheet is saved can be view in an explorer window. |
All times are GMT +1. The time now is 09:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com