Avatar of Murray Brown
Murray Brown
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Excel 2013 Open new Workbook

Hi

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

Avatar of undefined
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
ASKER CERTIFIED SOLUTION
Máté Farkas

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Qlemo

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Murray Brown

ASKER
Thanks
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes