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

Thank

Yong

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

Thanks a lot, Harald

C# version is

Microsoft.Office.Core.DocumentProperty prp;
Microsoft.Office.Core.DocumentProperties prps;

prps = (Office.DocumentProperties)Wb.BuiltinDocumentPrope rties
prp = prps["Last Save Time"]
DateTime workbookDT = (DateTime)prp.Value

Yong