Hi,

How can I switch from one excel application (instance to another) via VBA?

I have a workbook Book1 opened in an instance.I want my macro to open a new workbook (Book2) in a new instance of Excel (this part is working fine so far),
then copy cells from Book1 to Book2
and then copy cells from Book2 back on Book1 (that's the tricky part for me)

Does anybody know how i can do this ?

Thank you in advance,