Force Macro to NOT Open Workbooks in New Instance

[DougRobertson]

Hello,

Last week I was forced kicking and screaming into upgrading to Excel 2016 from 2010.
One of the changes I noticed was that each time I have the Macro open a workbook, it always opens it in a New Instance. This is most annoying for some of the actions I have it perform when multiple workbooks are opened.

Is there a way to force it to NOT always open a New Instance, but to keep all workbooks in the Original Instance, as in days of olde?

With Many Thanks!

~ DWR

 

[shg]

Are you sure it opens in a separate interface? Excel 2013 changes to a single-document interface, so it now behave more like Word.

What does Workbooks.Count return before and after opening a new workbook?

 

[shg]

Are you sure it opens in a separate interface?

Separate instance?

 

[DougRobertson]

Workbooks.Count returns 4 Workbooks before I open the New Workbook, and 5 Workbooks after I open it.

My Macros are quite integrated, so I have one Macro open another Macro in another Workbook etc.

They have all been working nicely for years now, mostly within the same Interface, and using the "Application.ScreenUpdating = False" code, it is mostly done behind the scenes.

Now with Excel 2016, it always opens new workbooks in a New Interface and everything is showing!

Thank you for taking a look at this!

 

[shg]

They are open in the same instance. The rest of your macro should work fine functionally, but some appearance aspects my be different. I don't have a version later than Excel 2010 to test.

 

[DougRobertson]

Okay - thanks for your efforts to help out on this anyway. Kinda frustrating when thing work so well for so long, only to have Microsoft change it up!

~ DWR

 

[shg]

I still haven't heard what the problem is.