MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date saved stamp


Posted by Rey on July 30, 2001 8:18 AM

Hi,

How do I automatically store the last save date of my spreadsheet file into a cell. Such that, I can just view this cell and be able to tell as to the last time (date) I saved this file.

Thanks a lot.
Rey


Posted by mseyf on July 30, 2001 11:27 AM


according to the VBA help:

ActiveWorkbook.BuiltinDocumentProperties.Item(12)

should return the 'Last Save Time', but it just gives an error(Excel97 sr-1). Maybe someone else knows why.