MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Accessing the Last Saved Date


Posted by Audri Peterson on January 16, 2002 12:39 PM

How do I display the "last saved date" for an Excel workbook?
Thanks!


Posted by Damon Ostrander on January 16, 2002 4:26 PM

Hi Audri,

Here's how to put it in a messagebox:

MsgBox Format(ThisWorkbook.BuiltinDocumentProperties("Last Save Time"), _
"short date"), vbInformation, "Date Last Saved"

or to write it to cell B4:

[B4] = Format(ThisWorkbook.BuiltinDocumentProperties("Last Save Time"), _
"short date")

Damon