Can anyone explain to me how to open a new instance of excel using VBA code?
What I am trying to achieve is, IF a user tries to open a new workbook in the existing instance of Excel, the application will open a new instance of Excel, and open the workbook at that location. Up to now, I have the following:
Public WithEvents App As Application Private Sub App_NewWorkbook(ByVal Wb As Workbook) 'Code should go here End Sub
The above code is the event handler for when a new workbook is opened. I need to somehow stop the workbook from opening in my current workbook, and open it in a new instance of excel instead.
Any suggestions will help.