Excel 2013 macro compatibility issue due to SDI RRS feed

  • Question

  • 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.


    Monday, February 23, 2015 4:38 AM