Excel 2013 SDI vs MDI - Setting Active Workbook When Opening from Code

[jbl25]

Hello,
Code working in previous excel versions is no longer working in 2013 - I open a file (say, source file) with code (say, destination file) to extract some data into a user form. Focus normally remains on the original (destination) workbook with the user form active. Now, focus goes to the opened (source) file, and I can't change the active workbook. Windows().Active and Workbooks().Activate does not work. Oddly, stepping through the code line by line does seem to work, but running the macro does not. Does this need to be handled differently with the SDI format?
Thank you!

[romperstomper]

There are some quirks with SDI and userforms. Why do you need to actually activate either workbook?

[jbl25]

Hi,
Once the destination file userform grabs some information from the source file, the user has to make some additional selections on the userform. So what's happening is the user only sees the source file, and it looks like the destination file and userform has disappeared - that's why it needs be active when the macro finishes. (And the source file needs to remain open as some additional operations are performed on that file to get data.)
Thanks!

[romperstomper]

That does sound like a bug. I don't have 2013 here to test but will try and reproduce tomorrow and see if it's a known issue. If not, I'll file it as a bug.