How do I open a new workbook in the same window. When I open a workbook it does it in a new window.
This is for my Excel VB.net Add-in which uses task panes.
Thanks
Visual Basic.NETMicrosoft ExcelMicrosoft Office
Last Comment
Murray Brown
8/22/2022 - Mon
Norie
Are you opening the workbook manually or with code?
Murray Brown
ASKER
Manually. My Excel add-in has a task pane. I want to open this and then open an existing workbook in the same instance of Excel. So far the only way I can see to do this is to close all workbooks and then open my file. Is this the only way to do this? I was hoping to find some sort of setting that would force each new open workbook to be in the same instance of Excel