none
Excel 2010 - Run-time Error '429': ActiveX component can't creat object RRS feed

  • Question

  • This is the code I'm using when I got the error Run-time Error '429': ActiveX component can't creat object

    My computer had a problem and I had to format and reinstall OS and all other softwares including Office 2010, after that this code stop working. Before it works perfectly.

    Can you help me answering my question to micaeld@br.ibm.com

    Public Sub STATUS()
    Dim autECLOIAObj As Object
    Set autECLOIAObj = CreateObject("PCOMM.autECLOIA")<<<<<<<<<------------
        autECLOIAObj.SetConnectionByName ("A")



    Dim autECLPSObj As Object
    Dim autECLConnList As Object
    Set autECLPSObj = CreateObject("PCOMM.autECLPS")
    Set autECLConnList = CreateObject("PCOMM.autECLConnList")


    autECLConnList.Refresh
    autECLPSObj.SetConnectionByName ("A")

    'declaração de C

    Dim x As Integer


    a = 2

    While Not a > 311

        Cr = Sheets("TODOS_STATUS").Cells(a, 1)
        chamado = Sheets("TODOS_STATUS").Cells(a, 2)

                
    Monday, September 24, 2012 8:33 PM

All replies

  • Probably before you have install drivers, added to system PCOMM.autECLOIA control.

    Now your vba procedure want to assign object to tis control without success.

    This is not standard MSO control - so you must find what program use it and reinstall this driver.

    If you have name of dll file - you can try register them into your system using regsrv32 (with admin rights), but better way is use public installer.


    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Tuesday, September 25, 2012 7:52 AM
    Answerer