Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
show date modified in a cell
How can I get the modification date of a file to display in a worksheet cell?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
show date modified in a cell
There is nothing built inot Excel to do this. Place this code in a VB module
(let me know if you need help with this) in the spreadsheet you need the last saved date in. Public Function LastSaved() LastSaved = ThisWorkbook.BuiltinDocumentProperties("Last Save Time") End Function In any cell you can now use the formula =LastSaved() and the last saved date and time will be displayed (make sure to format the cell as date). HTH "Lana" wrote: How can I get the modification date of a file to display in a worksheet cell? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
show date modified in a cell
This worked perfectly, thank you very much!!!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically show modified date? | Excel Worksheet Functions | |||
Display a Date when a cell is Modified | Excel Worksheet Functions | |||
how to show the date a spreadsheet was modified in a cell | Excel Discussion (Misc queries) | |||
Show date cell modified | Excel Worksheet Functions | |||
In adjacent cell, show last date modified of target cell. | Excel Discussion (Misc queries) |