Workbook to Open a new excel Window

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason Zischke - 22 Mar 2006 11:03 GMT

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

Reply to this Message

Martin - 22 Mar 2006 12:33 GMT

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

> Hi all,
>
[quoted text clipped - 4 lines]
>
> Jason Zischke

Reply to this Message