Excel 2013 wrong window activated from VBA

Dear alll,

I have a curious problem - I have a complex VBA project, part of which allows users to export 5 worksheets to a new workbook, after which the new workbook is activated. This works fine in Excel 2010 but when I run the code in 2013, 2 strange things happen:

1. the nb.Activate line in the code seems to activate the originating workbook and vice versa, ThisWorkbook.Activate shifts focus to the new workbook;

2. when clicking on the X to close the window of the new workbook, the originating workbook closes instead.

It's very frustrating and seems to be a problem only in Excel 2013 - it'd as if the Application processes are getting confused about the identity of the two workbooks but even when I use the code Workbooks("NewBook.xlsx").Activate instead, it still activates the wrong workbook. Has anyone else encountered this?

It is worth noting that this is happening while the originating workbook has two Userforms open in it - this could be a factor.

Any thoughts?

Ok, I have removed some of the code as it is proprietary, but here is the essence of it:

Please Login or Register  to view this content.

As may be apparent, there is a lot of jumping back and forth between the workbooks (hence not relying on the new book being active as a result of being created) but I have clearly set the new book back to being active at all necessary exit points...

So yeah, puzzled. As I say, it works in 2010...

I was trying a variety of different approaches, so in the code pasted here it actually uses "Application.Windows(nb.Name).Activate" instead - but the outcome is the same.

As for why jumping between workbooks, it is because changes are being made to both in the course of the code that has been omitted - it takes about 5-10secs to process everything, during which time the original workbook is displayed. Only at the end, once the export has completed, should the new workbook be visible and activated.

As I say, the code works perfectly in 2010.

I have and the frustrating thing is that nb is being referenced correctly so far as I can tell (using a debug.print to check the name)...

I think I have solved the problem - it seems to be related to the fact that the Excel application windowstate is Maximized.

When both the originating workbook and the exported workbook are maximised and I click on the X to close the exported file, it actually closes the original workbook, however, if I set the windowstate to normal, it closes the correct workbook.

What I have done, then, is to set the Application.Windowstate = xlNormal, activate the new workbook, then reset Application.Windowstate = xlMaximized. This forces the applciation to activate the correct window.

I'm fairly sure that this is an issue with Excel 2013 - do you have any thoughts?