Imagine you are working with VBA in Microsoft Excel, and suddenly you get stuck with “run-time error ‘429’: ActiveX component can’t create object”. Well, 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, regardless of the reason, it can be fixed easily. In this post, I will explain why this error occurs and how to fix runtime error 429 in Excel with less effort.
To fix corrupted Excel files, we recommend this tool:
This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:
- Try Excel File Repair Tool rated Excellent by Softpedia, Softonic & CNET.
- Select the corrupt Excel file (XLS, XLSX) & click Repair to initiate the repair process.
- Preview the repaired files and click Save File to save the files at desired location.
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:
- Incomplete installation of software/system files
- Due to a corrupted registry
- Deleted OS files
- Malware or virus attack
- 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 to Fix Runtime Error 429 In Excel
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 3rd-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.
Steps to Run Excel Repair Software
Related FAQs:
What Is Unexpected Error Number 429 Has Occurred?
An unexpected error number 429 has occurred when a program tries to prepare an ActiveX control, and the required object is unavailable.
How Do I Fix ActiveX Errors?
You can fix ActiveX errors by following these steps:
- Go to the Tools menu then open Internet Options >> select the Security tab.
- After that, reset a system file MSXML.dll.
- Next, click on the Windows Start button.
Should I Delete ActiveX Controls?
No, you should not delete ActiveX control, as it can lead to risk and potential damage to the file and its objects.
How Do I Enable ActiveX Settings?
If you want to enable ActiveX settings, follow these steps:
- Go to File tab >> under the Security Warning area, you have to click Enable Content.
- After that, in the Enable All Content, simply click on Always enable this document's active content.
How Do I Align ActiveX Controls in Excel?
To align ActiveX controls in MS Excel, you have to:
- Choose the controls. Then, see Select or deselect controls on the spreadsheet.
- To align the controls, you have to click on the Drawing Tools Format tab >> then click the arrow next to Align.
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.
External References:
