Looping through Excel Applications
 

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

Looping through Excel Applications
 

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

Looping through Excel Applications
 

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


"Harald Staff" wrote:

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