Switching between workbooks open in different instances

Hello everyone,

I have to work with two workbooks and paste some information of #1 into #2. They are both open in different excel instances and the macro I am trying to code is stored in the PERSONAL file, so it is available everywhere.

I am trying to use the Application.Workbooks(x).Activate method, in which "x" is the number of each open workbook according to the order in which they were opened.

Let's say that I run the above-mentioned command in a macro, launching the macro from file #1. The x becomes 1 for the PERSONAL file and 2 for the #1 file itself. If I put x=3, the macro gives me an error, as file #2 is in a different Excel instance and does not get recognised.

It there any way to select file #2 launching a macro stored in PERSONAL from file #1?

Thanks in advance for your help!

Have a read of http://www.ozgrid.com/forum/showthread.php?t=182853

There's 2 examples in the thread, the second can be used to return a reference to a workbook or worksheet in another instance of Excel - you can then use that reference in code...

Please Login or Register  to view this content.

You may be able to apply it your your particular requirements...

Looks like a lot of info, I'll study this and let you know the results. Thanks for the help!