(Solved) – Timestamp of last workbook modification after it was saved (not the last saved time)


I need to know when an Excel workbook was last modified after it was saved.

Lets say I saved the file, and after I saved it, I modified something that triggered the workbook.Saved = false. How to get the timestamp of this last change made to the workbook ?

I am aware of the ActiveWorkbook.BuiltinDocumentProperties("Last Save Time") but this only gives me the timestamp of the saved file and does not take in account any modifications made after the save.

Anyone know if this is possible? I found nothing online, and no BuiltinDocumentProperty has this information.

Leave a Reply

Your email address will not be published. Required fields are marked *