locked
Crash when closing Excel after deleting an ActiveX Control RRS feed

  • Question

  • Using the ActiceX Control from this Excel Add-In: http://www.tec-it.com/en/download/tbarcode-office/Download.aspx

    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: http://www.tec-it.com/en/download/tbarcode/Download.aspx

    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

  • Hi,

    This is forum discuss questions and feedback for Microsoft Excel features, since your issue is related to a third-part add-in, we will suggest you contact their support team for help. For the current thread, i will move to Off Topic forum:

    https://social.technet.microsoft.com/Forums/office/en-US/home?forum=Offtopic

    Regards,

    Emi


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Tuesday, May 15, 2018 7:52 AM