compare workbooks version number

[Pawel]

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

[Trebor76]

Hi Pawel,

Have a look at this DSO method (http://www.vbaexpress.com/forum/showthread.php?6827-Fetching-Object-Properties&highlight=DSOFile)by xld.

Regards,

Robert

[Pawel]

Thanks Trebor. I'll try to use that .