Excel VBA code to look through all open instances of excel

[ben_sorensen]

I have written a code that looks for specific data in a different workbook, but the issue that I am having now is that it won't look through other open instances of excel, which is driving me crazy! If anybody has any insights in how to make excel look into ALL open instances of excel I would really appreciate the help.

Here is my code on searching for the workbook:

Workbooks(Trim(Sheets("General Manager Report").Range("C6").Value)).Sheets("Demand Planning").Range("A1:DZ250").Copy

I am desperate, every time I look something up and try and add it into the it pops an error.

Thanks for looking!

Best

 

[Joe4]

Here are a few links that deal with that issue:
https://excelribbon.tips.net/T009452_Finding_Other_Instances_of_Excel_in_a_Macro.html
https://stackoverflow.com/questions/2971473/can-vba-reach-across-instances-of-excel

 

[ben_sorensen]

Great thanks for posting


So I added the things from the post and now it is popping an error on me, here is my code:

Set xlApp = GetObject(Workbooks(Trim(Sheets("General Manager Report").Range("C7").Value))).Application.Sheets("Demand Planning").Range("A1:DZ250").Copy

Any help would be super appreciated!

Best