Loop through workbooks in different excel instances

[svjensen]

I use a macro to loop through all open workbooks, extracting data from them.
This work fine except that I found out that if some of the workbooks are opened in an other instance of excel they are not included.

Can I force the macro to run through all instances of excel and then through all workbooks in each instance?

 

[Norie]

It might be an idea to try and find out how the workbooks are being opened in separate instances.

Is it meant to be happening?

I'm sure it'll be possible to loop through the different instances but it's not going to be straightforward.

You would probably need to use the Windows API, which might involve looping through every 'window' that's open.

Then you would need something that identifies the instances of Excel, creates some sort of reference to them and then loop through the workbooks in each.

I think this has been answered on the board before - try a search.