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.