Workbooks collection only returns one open workbook in Excel 2016

[myfathersson]

Hi.

I have a program that has been running without a hitch since Excel 2007. A user signed up to Office 365 got upgraded to Office 2016. Now the program fails when looking for a specific open workbook. Here is the code where the failure occurs:

Please Login or Register  to view this content.

The line

Please Login or Register  to view this content.

only returns a single open workbook, usually the workbook containing the code. It doesn't seem to matter how many workbooks are open, the workbooks collection only returns a single workbook. Since the workbook being looked for isn't found, the routine always returns a null object reference even though the desired workbooks is open. I tried putting "Application." before "Workbooks" in the hope that it would more specifically qualify the collection...to no avail.

Has anyone seen this issue and, if so, was any solution found. In the research I've done so far, it appears 2016 opens new instances of Excel with each open workbook. I'm guessing they have a bug in the code that only sees open workbooks in the current instance of Excel, which is why the collection only contains a reference to the workbook containing the code.

Hope someone can help.

Peter

[Norie]

Peter

I use Excel 365 too and when I open mulitple workbooks they all open in the same instance though each workbook has it's own tab on the taskbar.

In the workbook with the code what does the user see in the Project Explorer of the VBA IDE?

What do they see there in the other workbooks?

[myfathersson]

Norie,

I didn't think to look specifically at what the IDE was showing when I was at the office. It'll take some time to answer your question because I don't have a test environment set up for 2016 yet. Need to set up a VM. I'll get back to you ASAP.

Thanks
Peter