8 Working Fixes for Runtime Error 429 In Excel

While working with VBA in Microsoft Excel, users often encounter peculiar errors and issues that hinder users. One such error that users are currently facing and reporting is- “run-time error ‘429’: ActiveX component can’t create object”. This error typically arises when an Excel program or script tries to access the ActiveX component that is registered incorrectly or installed improperly on your PC. It occurs due to various reasons. In this post, I will explain why this error occurs and how to fix runtime error 429 in Excel with less effort.

So, if you have also encountered the same error message, you must check out this post and follow the step-by-step workarounds mentioned here.

Quick Fixes:

1. Repair Corrupt System Files
2. Update Windows
3. Using Command Prompt
4. Run the Virus Scan
5. Execute System Restore
6. Check & Change the ActiveX Settings in Excel
7. Re-register the Excel Application
8. Ultimate Solution- Try Excel Repair Software

What Does Runtime Error 429 ActiveX Component Can’t Create Object Excel Mean?

When the “runtime error 429: ActiveX component can’t create object” occurs in MS Excel, it means that there’s an issue with the ActiveX control that Excel is attempting to use, but the program is unable to create/access this object. Either the component is missing or not registered properly on your computer.

However, this error occurs due to a wide variety of reasons. Here I have listed the major ones:

1. Incomplete installation of software/system files
2. Due to a corrupted registry
3. Deleted OS files
4. Malware or virus attack
5. Improper file extension registration.

After knowing the common causes, let’s know how to troubleshoot run-time error 429 VBA with the best fixes.

Fixes for Runtime Error 429 In Excel

Let’s explore the corresponding fixes to the causes mentioned above to deal with this error.

Fix 1- Repair Corrupt System Files

Corruption in the system files is one of the major reasons for 429 runtime error. To solve it, you can try to repair the Windows system files by following the below steps:

Step 1- First, press the Windows + R keys together to open a Run box.

Step 2- Type in CMD & click OK.

Step 3- Once the command prompt run as administrator window opens, you have to type sfc/scannow & hit Enter.

Step 4- After completion of the file repairing process, restart your computer.

Now, launch any Excel application to check if the error is solved or not.

Also Read: Runtime Error 424′ Object Required in Excel- 7 Methods

Fix 2- Update Windows

Running an outdated version of Windows OS can lead to various errors and issues including the ActiveX component can’t create object Excel.

So, if you are suspicious that your operating system is outdated, then consider updating it by following these steps:

• Initially, go to the Start >> Settings.
• Next, click on Windows Update.
• Now, click on Check for updates button to get the available updates for your system.

Fix 3- How to Fix Runtime Error 429 In Excel Using Command Prompt?

Many users have reported that they received runtime error 429 in Excel because of corrupted registry files. In that case, again registering the specified OCX & DLL file by running the command prompt can help you to deal with the error.

Here is how you can do so:

• Go to Start >> type CMD (Command Prompt) >> select run as administrator.

• Then, a cmd window will appear on your screen, Type regsvr32 or regsvr32 filename.ocx& hit Enter. (Here, replace your filename with an actual file name stated by the error)

Fix 4- Run the Virus Scan

Sometimes, it happens that the file gets infected by a malicious virus, and due to this the Excel file gets corrupted & displays an error. In such a situation, running the full virus scan with a 3^rd-party antivirus program can effectively fix the Excel ActiveX component error 429.

There are various antivirus tools available that fit all types of budgets and needs. So, try them according to your budget and needs.

Fix 5- Execute System Restore

Another option that you can try to solve this error is performing the system restore.

Though, System Restore is a Microsoft Windows feature that allows users to revert the computer’s system files & settings to a prior state. Also, it helps to get rid of system errors or issues triggered by software installations, updates, etc.

Here are the steps to perform the system restore:

• Go to the Search and type Create a restore point, then click on the first result.
• Under the popup window, you have to go to System Protection tab & click on System Restore button.

• After this, click Next to continue. Here, you have to select the current system restore point & follow the onscreen instructions to operate.

• This will reboot your PC automatically. After this, check if the problem is fixed.

Fix 6- Check & Change the ActiveX Settings in Excel

You can receive the “ActiveX component can’t create object” error if your MS Excel file holds macros, controls, & other interactive buttons. However, it typically occurs if an ActiveX Controls option is disabled. Changing the ActiveX Settings can assist you in fixing the problem.

Follow the below steps to check & change the ActiveX Settings:

• Open Excel.
• Go to a File >> then Options.
• Under Excel Options, you have to click on Trust Center tab.
• Under Trust Center Settings, you have to click on the ActiveX Settings.
• In ActiveX Settings, ensure to select “Disable all Application Add-ins” option >> click OK.

• Finally, restart the MS Excel & check for the error.

Also Read: Fix Runtime Error 9 Subscript Out of Range in Excel

Fix 7- Re-register the Excel Application

If an Excel program is displaying the run-time error 429 ActiveX component, then it is likely that the software might be incorrectly configured. By re-registering the Excel application, you can feasibly solve the error message.

Follow these steps to do so:

• First of all, see the path of the Excel file (.EXE file). The complete path of the file will seem like:

C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE.

• Next, open a Run Then, you have to copy & paste the complete path in that box.
• At this time, type /regserver behind a full path of the file. As for example- C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE /regserver.
• Now, hit Enter key & wait until the application is re-registered successfully.

Ultimate Solution- Try Excel Repair Software

Most of the Excel errors are mainly triggered due to corruption in the Excel file. In this circumstance, opt for the recommended Excel Repair Tool to repair the corrupt Excel XLS or XLSX workbook with 100% integrity.

This program can solve all types of MS Excel errors & restore all the workbook data, like tables, charts, images, formulas, cell comments sorts, and filters.

The best thing about this tool is- that you can even try the free demo version of this software to scan and preview recoverable data from a file.

Download       Buy Now

* Free version of the product only previews recoverable data.

Steps to Run Excel Repair Software

Closure

If you are facing run-time error 429 VBA in Excel, try resolving the error by implementing the fixes discussed in this post. However, if the manual approaches don’t fix the ActiveX component can’t create object, you can rely on an advanced solution- Excel Repair Tool to repair & restore your .XLS/.XLSX workbook data successfully.

For further queries, feel free to contact us through Twitter or Facebook, and stay tuned with us for the latest articles.