Crash when closing Excel after deleting an ActiveX Control RRS feed

  • Question

  • Using the ActiceX Control from this Excel Add-In:

    How to reproduce:
    Add Barcode ActiveX Control => Prog ID: TBarCode10.TBarCode10 (either through the Add-In Panel or through Developer toolbar for adding ActiveX Controls)
    Save the sheet
    Re-open the sheet
    Delete the Barcode (ActiveX Control)
    Close Excel (don't save) => Crash / Excel restarts

    Microsoft Office 365 ProPlus Version 1708 (Build 8431.2242 Click-to-Run)
    Windows 10 Pro

    This crash does not occur in Microsoft Office Professional Plus / Excel 2016 (16.0.4639.1000). There must have been a change in Office 365 handling ActiveX Controls (deinitializing), which causes this crash. It occurs only when an ActiveX Control has been deleted and afterwards Excel is closed.

    Same problem occurs also with the TBarCode11 ActiveX Control:

    The ActiveX is built with Microsoft ATL Visual Studio 2015. Debugging the problem with TBarCode V11 shows that the crash occurs in atlctl.h - CComControlBase::IOleObject_Close with the pIPO pointer returned by ControlQueryInterface being NULL. The m_bInPlaceActive is TRUE, which I believe is wrong (in Excel 2016 without crash it is FALSE). Looks like a bug in ActiveX handling in Excel.

    Note: It is not a problem of the TBarCode ActiveX Control since this worked in all previous versions of Excel. The crash occurs also inside of the ATL framework (which is from Microsoft).

    I request that the ActiveX Control handling is verified once again and the bug is fixed in upcoming release(s).

    Monday, May 14, 2018 2:23 PM

All replies