Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
Inserting the date that an excel sheet is saved into a cell | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |