Hi Yong

Try
ThisWorkbook.BuiltinDocumentProperties("Last Save Time")

HTH. Best wishes Harald

"Yong" skrev i melding
...
Hi

In the Workbook_Open() event handler I want to check the last write date
time of the workbook. But I always get the current date time. I suspect this
event handler occurs after the workbok has been opened. Any idea to get the
last write date time of a workbook when opening it?

Thanks

Yong