Archive of Mr Excel Message Board
Back to Excel VBA archive index
Back to archive home
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!
| Check out our Excel VBA Resources
|
 |
 |
 |
 |
 |
Re: Accessing the Last Saved Date
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
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.