Debug Error Message - "Run Time Error 429" ActiveX component can't create object

[Sharid]

Hi

My code that was working fine a month back, now i keep getting this run time error message when I run the code.

Debug Error Message - "Run Time Error 429" ActiveX component can't create

It happens on this point shown in Red, I have not posted the full code

'Set IE = InternetExplorer
    [COLOR=#ff0000]Set ie = CreateObject("InternetExplorer.Application")[/COLOR]
    Rows = wsSheet.Cells(wsSheet.Rows.Count, "A").End(xlUp).Row
    links = wsSheet.Range("A1:A" & Rows)

I have not changed anything, can't work out why it has stopped working

 

[mole999]

references available to support ie or activex ?

 

[Sharid]

Sorry Mole999 I'm not 100% sure what you are asking for, do you mean

Tools > References in the visual basic editor, if so the following are active

• Visual Basic for Applications
• Microsoft Excel 15.0 Object Library
• OLE Automation
• Microsoft Office 15.0 Object Library

• Microsoft HTML Object Library
• Microsoft Internet Controls
• Microsoft Form 2.0 Object Library
• Microsoft XML v6.0
• OLE Automation
• Microsoft JScript

As I said the code was working last month, but not now

 

[mole999]

so what has been added or updated since last working run

 

[Sharid]

Windows 10 did an update, apart from that nothing.

I tried to repair MS office but that did not work, via control pannel > change > repair

 

[Sharid]

Hi can someone please help me on this one, I am really stuck.

I have tried to do Office repair that did not work, so i did an office upgrade today to office 2016 and that still has not worked. I am still getting the 429 error message, when I run my code.

My VBA does not work, The only thing I can see that was changed is a windows 10 update. I don't want to uninstall and reinstall windows as that migh not even fix this.


Thanks for having a look

 

[Sharid]

I know this is not a PC fixing forum, but is this part of the problem? See picture in link

https://app.box.com/s/wrf2co4hc6hj12s0iekoeqr3blwnqgld

Do I have missing files in my registry?

This is the step I followed to check my registry and as you can see from the picture it is mainly empty

Step 2 – Verify the Registry Entries for Office Applications

You can run the Registry Editor tool to check for the Office application entries. To do so follow these steps:

1. Click Start and then Run.
2. Type Regedit and press Enter.
3. Navigate to HKEY_CLASSES_ROOT\CLSID key in the Registry Editor window that is displayed.
4. Ensure that LocalServer32 key uses the correct path and it matches to the location of the file.
   

The common Office CLSID keys are:

Access.Application {73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9}
Excel.Application {00024500-0000-0000-C000-000000000046}
FrontPage.Application {04DF1015-7007-11D1-83BC-006097ABE675}
Outlook.Application {0006F03A-0000-0000-C000-000000000046}
PowerPoint.Application {91493441-5A91-11CF-8700-00AA0060263B}
Word.Application {000209FF-0000-0000-C000-000000000046}


To find the correct path names, type each of the paths in the Run dialog box with ‘/ automate’ in the end and if the application runs fine, then it is installed properly. If the application does not run, then you will need to change the path in the LocalsServer32 key. If this doesn’t solve the problem, try the next step.

 

[mole999]

try this > https://www.microsoft.com/en-us/download/details.aspx?id=36852

 

[Sharid]

Thanks Mole999 the utility link you gave me, helped id other issues for which I was able to download some updates.

However I am still having the same VBA issue with my excel, that is still unresolved.

 

[Sharid]

Bit of a stupid question,

With the NEW windows 10 update, I can no longer see Windows Explorer only Windows Edge, is this the cause of the problem as there is NO windows Explorer to open

I tend to use firefox so never noticed this.