show date modified in a cell
 

How can I get the modification date of a file to display in a worksheet cell?

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?

show date modified in a cell
 

This worked perfectly, thank you very much!!!