Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I created a function in Excel to display the "Last Saved Date and Time" in a
cell. The code is as follows: < Function LastSaved( ) LastSaved = ActiveWorkbook.BuiltinDocumentProperties.Item(12) End Function After saving the modified file, the cell displays the "Last Saved Date and Time". I tried to modify the file another time and saved it. The cell however does not change to the new date and time. But this was reflected under the File - Properties - Statistics. How can I update the cell to continuous display the right date and time whenever the "Save" button is clicked ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel should have a function for last date and time file was saved | Excel Worksheet Functions | |||
Query to find last saved date/Time | Excel Worksheet Functions | |||
How to have:= NOW () date/time change only if updated and saved | Excel Worksheet Functions | |||
How do I put a "date & time saved" stamp inside an Excel Wksht? | Excel Programming | |||
How do I put a "date & time saved" stamp inside an Excel Wksht? | Excel Programming |