| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Workbook As Seperate Window
I would like to open a new workbook in a separate window. I have set up Excel
to do this when you double click a file to open but when doing it programmatically, it always opens inside the activeworkbook. How can a new workbook be added in a separate window? Excel 2003/Windows XP. Dim targetWorkbook As Workbook Set targetWorkbook = Application.Workbooks.Add |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Add Workbook As Seperate Window
If you give the TargetWorkbook a name and then save it, it should then be a
separate window from the workbook that was active when the new one was created. Otherwise, I would think maybe opening a secon instance of Excel might be what you are after. "George Lee" wrote: I would like to open a new workbook in a separate window. I have set up Excel to do this when you double click a file to open but when doing it programmatically, it always opens inside the activeworkbook. How can a new workbook be added in a separate window? Excel 2003/Windows XP. Dim targetWorkbook As Workbook Set targetWorkbook = Application.Workbooks.Add |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking formulas from seperate workbook | Excel Worksheet Functions | |||
| Formulas within workbook but seperate sheets. | Excel Worksheet Functions | |||
| new speadsheets open in seperate window | Excel Worksheet Functions | |||
| Can Excel open each workbook in a seperate window | Setting up and Configuration of Excel | |||
| how to get excel to open in a new, and seperate window with each . | Excel Discussion (Misc queries) | |||
Linear Mode
