| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I open a workbook using a different window | Excel Discussion (Misc queries) | |||
| Detecting if a Window/Workbook is Open | Excel Discussion (Misc queries) | |||
| How to open Excel workbook in full size window | Excel Discussion (Misc queries) | |||
| Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
| Can Excel open each workbook in a seperate window | Setting up and Configuration of Excel | |||
Linear Mode
