Multiple Instances of Excel

[c_leven3]

I'd like to use VBA to open 3 workbooks in their own session/instance/etc of Excel 2007. Ideally, there will be one main workbook, that upon opening will subsequently open the other 3 workbooks.

Also, when I open that first main workbook, I will obviously have to enable macros to get any code to run. Is there a way to carry this enabling of macros over to the other sessions to avoid having to enable macros in all 3 other workbooks? (Changing my security settings isn't an option)

Thanks in advance,
Kyle

[shg]

Macros are enabled by default when you open a new Excel session via VBA.

[Leith Ross]

Hello c_leven3,

Here is a macro that will create a new instance of Excel when run.

Sub StartExcel()
  Dim xlApp As Object
    Set xlApp = CreateObject("Excel.Application")
    xlApp.Visible = True
    xlApp.WindowState = xlMinimized
    Set xlApp = Nothing
End Sub

[c_leven3]

Great! Thanks to both of you.