Application.Workbooks.Open In a New Window

[cicconmr]

Is there a way to open the new file in a seperate window? Or will it always open in the current window amongst the other spreadsheets you have open.

Thanks,

Matt

 

[AlphaFrog]

Sub test()
    Dim xlApp As Excel.Application
    Set xlApp = CreateObject("Excel.Application")
    xlApp.Visible = True
    xlApp.Workbooks.Open Filename:="C:\temp\test.xls"
End Sub

 

[cicconmr]

Would it make sense that this causes all my add-ins to unload?

When I do it this way Add-Ins crucial to the Workbook just stop working...