Wouldn't it be opened as Readonly if another instance has it open ?

HTH. Best wishes Harald

"big t" skrev i melding
...
Hi Everyone,

I have some code that opens up a workbook in a new instance of Excel. But
before it opens the workbook I want to check to see if it has already been
opened.

So I need to loop through all the open workbooks in all the instances of
Excel - but how do I do this?

Any ideas???

TIA,

big t