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 |
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 |
All times are GMT +1. The time now is 06:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com