Workbook to Open a new excel Window

[Guest]

Hi all,

Is there a way to get a workbook to open in a new excel window rather then
one that is open?

Thanks in Advance

Jason Zischke

 

[Guest]

This should do it (make sure M/soft Excel Object Library is ticked in Tools,
References but it should be if you're in Excel already):

Sub OpenInNewExcel()
Dim myExcel As New Excel.Application
myExcel.Workbooks.Open ("[path to your file]")
myExcel.Visible = True
End Sub