+ Reply to Thread
Results 1 to 9 of 9

Cannot insert object, ActiveX control does not not work anymore

  1. #1
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Cannot insert object, ActiveX control does not not work anymore

    Good morning guys,

    I,m facing with a strange issue, yesterday (until yesterday all of them worked without any troubles)one of my colleague called me from office and told me that our excel files did not work properly anymore.
    The files have commandbuttons (activex control) in sheet and are disable, cannot do anything with them. When I open (one of them) the file in workbook-open I have some commandbuttons hidden and when the user completes some textboxes in UserForm some commandbuttons (activex control) should apper but they did not. I tried to see what caused it but I have had no idea. Moreover, I try to create a test file adding an activex control -commandbutton and the message is "Cannot insert object".
    Please tell me what should I do to solve this issue...I really appreciate your help.
    I use win7 at home and at office also, I did not do any "update" or something similar, I did not do anything.
    Last edited by john55; 12-12-2014 at 02:33 AM.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Cannot insert object, ActiveX control does not not work anymore

    There is a problem with the latest Office update.

    The interwebs is buzzing with posts about it. Bottom line:

    Close all Office applications, do a system wide search for *.exd and delete all that you find. Reboot. Hope.

    See here: http://excelmatters.com/2014/12/10/o...ivex-controls/

    or here: http://dailydoseofexcel.com/archives...ivex-controls/

    or here: http://www.infoworld.com/article/285...root-cert.html

  3. #3
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: Cannot insert object, ActiveX control does not not work anymore

    Hi Teylyn,
    Wow! Excellent advice! Thank you very much for your help!
    I tried it and it seems to be ok. the files from my laptop work fine after I deleted the .exd files. Hope to be ok with the files ffrom our office.



    Best Regards,
    George

  4. #4
    Registered User
    Join Date
    04-10-2014
    Location
    Tallahassee, FL
    MS-Off Ver
    Excel 2010
    Posts
    98

    Re: Cannot insert object, ActiveX control does not not work anymore

    I ended up having to rewrite my code to use drop-down boxes in UserForms instead of ActiveX controls because of this latest update. Searching for those files didn't fix the problems.

  5. #5
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: Cannot insert object, ActiveX control does not not work anymore

    Phixer,
    try this way
    Note: if you are having problems locating the .exd files, you can press Win+R to open the Run box, enter %temp% and press Enter. That should open explorer to the Temp folder and you then need to look in the Excel8.0 and VBE folders for the .exd files. (if your issue is with a program other than Excel, look for the folder related to that application – e.g. Word8.0)

  6. #6
    Forum Contributor
    Join Date
    08-29-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    103

    Re: Cannot insert object, ActiveX control does not not work anymore

    New windows path downloaded today. Did it fix the issue?

  7. #7
    Registered User
    Join Date
    07-29-2014
    Location
    CA, USA
    MS-Off Ver
    2010
    Posts
    12

    Re: Cannot insert object, ActiveX control does not not work anymore

    thanks for the diagnosis! whatever would I/we do without the internet!

  8. #8
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Cannot insert object, ActiveX control does not not work anymore

    Here is the official MS post on the Excel blog:

    http://blogs.technet.com/b/the_micro...-updates-.aspx

    They've changed the post title once already and links to the first version broke. In case they decide to change the post title again, here is the blog landing page.

    http://blogs.technet.com/b/the_micro...ort_team_blog/

    cheers, teylyn

  9. #9
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: Cannot insert object, ActiveX control does not not work anymore

    Hi Teylyn

    I followed the same "procedure" at office and all our excel files work as expected!
    Thanks a lot for this help!

    cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 09-24-2014, 12:30 PM
  2. multiple instances of excel and activeX control object
    By vientito in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-21-2014, 01:02 PM
  3. Macro code to change the ActiveX Control Object Properties
    By jackgan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-07-2013, 02:31 PM
  4. ActiveX control can't create object
    By rkjudy in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 08-04-2009, 12:08 PM
  5. GetObject Error 429 - ActiveX control cannot create object
    By EAB1977 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2006, 09:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1