Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Save Date
Any way the spreadsheet can display the last save date time of the spreadsheet?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Save Date
Set the Security level to low/medium in (Tools|Macro|Security). From workbook
launch VBE using short-key Alt+F11. From menu 'Insert' a module and paste the below function.Get back to workbook.. Function DocProperty(strQ As String) Application.Volatile DocProperty = ActiveWorkbook.BuiltinDocumentĀ*Properties (strQ) End Function For a already saved workbook enter the formula in any cell.. =DocProperty("last save time") If this post helps click Yes --------------- Jacob Skaria "tomen24" wrote: Any way the spreadsheet can display the last save date time of the spreadsheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recovering File Info Specifically Save Date or Print Date | Excel Discussion (Misc queries) | |||
Save username and date | Excel Discussion (Misc queries) | |||
Last Save Date | Excel Discussion (Misc queries) | |||
save as future date eg expected delivery date | Excel Discussion (Misc queries) | |||
add a date that changes only when I save the doc. | Excel Worksheet Functions |