Open NEw instance of Excel through MAcro

[taufiq_786]

Is there a way to specify in VB to open a workbook in a new instance of Excel?

I.E. if I have a workbook open already, and I navigate to an excel file and double click it will open that file in the same instance of excel. But, if I have an excel file open and I go to Start Menu, Excel, then I have a totally seperate instance of Excel.

The reason I need to do this is I have a task that requires to seperate macros to run concurrently, and the only way I know of to accomplish this is in two seperate instances of excel. But I would like a way to programmatically accomplish this, instead of having to manually open two instances and fire two macros..

Essentially what I want to do is have a macro in WB 1 that when fired will open WB 2 in its own instance, then continue through its own code. WB 2 will have a Workbook.Open event that will subsequently fire its own macro, effectively starting both macros to run concurrently with a single button press.

Has anyone done this or can you point me in the right direction to open a 2nd instance of Excel through VB?

 

[Andrew Poulsom]

I think you're going to need to split the data into 3 workbooks in the current instance of Excel and save and close them. Then you should be able to open them in separate instances of Excel and run any macros that they contain.

Copy/paste between Excel applications doesn't work like it does within a single application. It's like copy/paste from Excel to Word.