Looping through Excel Applications

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Wouldn't it be opened as Readonly if another instance has it open ?

HTH. Best wishes Harald
 
It would - but I don't want it to get that far! I want something like this:

- user chooses menu option to open the specified workbook
- code checks to see if it's already open (in any instance of Excel)
- if it's not open then open it in a new instance of Excel
- if it is already open, do nothing

so I still need to check if it's open or not.

cheers
big t
 
Back
Top