taufiq_786
New Member
- Joined
- Jan 23, 2007
- Messages
- 10
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?
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?