Pawel
10-17-2016, 10:16 AM
Hi guys,
I would like to compare version numbers of 2 workbooks without opening the 2nd one ( If it's possible). So far I have sth like this:
If wb.BuiltinDocumentProperties("document version") = Workbooks.Open("C:\Users\paw\Desktop\Test4\test22.xlsm").BuiltinDocumentProperties("document version") Then
and it works, but I really need to do that without opening the 2nd workbook.
Please help
I would like to compare version numbers of 2 workbooks without opening the 2nd one ( If it's possible). So far I have sth like this:
If wb.BuiltinDocumentProperties("document version") = Workbooks.Open("C:\Users\paw\Desktop\Test4\test22.xlsm").BuiltinDocumentProperties("document version") Then
and it works, but I really need to do that without opening the 2nd workbook.
Please help