MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date saved stamp

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


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.

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

according to the VBA help:


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