Excel 2013 is now SDI. If I have a macro that needs to open a separate instance of Excel to kick off a long calculation, the following code no longer opens the file in a separate instance:

Dim xl As Application
Set xl = New Application

I tried spawning a new process using excel.exe /X, but this has the unfortunate effect of causing strange  COM Exceptions HRESULT 800AC472 when writing to certain cell values. I need a reliable method to open a separate excel instance programmatically, as 2013 has essentially broken compatibility with many macros by trying to share instances.

Thanks

Hi,

Please see the article and check if it is helpful.

https://msdn.microsoft.com/en-us/library/office/dn251093.aspx?f=255&MSPPError=-2147217396

PSThis is the forum to discuss questions and feedback for Microsoft Excel, if you have further question, I recommend post the question to the MSDN forum for Excel

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.