Working with multiple Excel instances

Hi,

I am using Microsoft Excel for Microsoft 365 MSO (Version 2312 Build 16.0.17126.20132) 64-bit and whatever code I use needs to be also be compatible with MS Excel 2016 32-bit version.

I have searched various forums to get an effective solution for working with multiple Excel files opened in separate Excel instances however have not found any easy and straight forward way of referencing and doing simple operations such as copy from excel in one instance and paste to another etc.

A 3rd party application is opening 2 excel instances with 1 excel file opened in one instance and 2 excel files in another excel instance. The 2nd instance has the .xlsm file which is supposed to have a macro that will do various operation such opening additional files, filtering, copying, pasting data etc from one file to another and then saving the files. Any new file that the macro opens, by default opens in the 2nd Excel instance and is easily referenceable using the filename however the 1 excel file which is opened in a separate instance is not referenceable using file name. I have tried the below but am getting an error...

Please Login or Register  to view this content.

Try it:

Please Login or Register  to view this content.

Artik

Originally Posted by Artik

Try it:

Please Login or Register  to view this content.

Artik

This hung my system, probably because the file is already open.

To clarify, there are 2 excel instances - Macro runs from an excel file in one instance and 'Pth_new & FileName3' is already open in another instance.

The macro opens more files (which open in the same instance as the macro file by default) and has to do various operations such as filter/copy/paste/save file across all the opern files, including the file that is open in another instance.

I am looking for a straight forward way of referencing this one file, which is in a different instance to enable all the routine operations to be performed on it.

In this case, you should follow the same way as in your other thread. In a collection of Excel instances, find the appropriate file and assign it to a variable.

Artik

Originally Posted by Artik

In this case, you should follow the same way as in your other thread. In a collection of Excel instances, find the appropriate file and assign it to a variable.

Artik

Atrik, Thanks for nudging me in the right direction. The link you provided was extremely helpful in understanding how to reference workbooks in different excel instances, just as per my requirement. I also wanted to share another link that I came across in Excelforum which has comprehensive codes for all relevant use cases which might be of help to others, but the forum rules restricted me from sharing links, hence sharing a lead here - Search keyword: macro-to-close-every-workbook-in-all-excel-instances (refer to response by LJMetzger - his response also has a downloadable file embedded with the codes which I am sure would be useful to anyone who wants to dig deeper). Thanks again for your help...Cheers!