Multiple instances of excel when running macros between sheets

[tomleitch]

Hi all,

I have some code that runs and opens another sheet to pull data from it. (the code checks if the sheet is open first and opens it if not).

The issue that I'm having is that occasionally when I open the second sheet it opens a new instance of excel and then it can't see it.


Is there any way around this?


Thanks
Tom

 

[MUKESHY12390]

you need check to "Is there object declare for Excel application". if then remove it.

or simply you can post sample code here we could suggest something.