Workbook to Open a new excel Window
 

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

Workbook to Open a new excel Window
 

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


"Jason Zischke" wrote:

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