
How to Fix Runtime Error 429 Caused By Automation Server
What are the causes of Runtime Error 429?
When you are trying to automate Microsoft office softwares such as word or excel using macros or visual basic scripts, Runtime Error 429 occurs! A better example is using a Visual basic script to access the database information from Microsoft Access file and that inputting that information into Microsoft excel file and then using it to compute statistics or create a chart from it or whatever. So what is the other better way to automate those kinds of operations? Well, you can use an automation server that run on windows COM architecture! So what exactly an automation server does is to allow your office applications to access COM architecture as an independent function within the file or as an executable files that automate tasks.
Ok, let’s talk about how the Runtime Error 429 appears on the screen; it goes something like this,
“Run-time error 429 – ActiveX component can’t create object”
So, to summarize the Runtime Error 429 occurs because if you are trying to use Microsoft Visual Basic script to create a new object function or new operator that executes certain tasks associated with a Microsoft office applications.
How to Fix Runtime Error 429 using an Automation server troubleshooting?
The first step is to make sure you don’t have faulty application setups and configurations. This will make sure that you don’t have a server problem. How to make sure that you don’t have a faulty setup? The solution is to find it out. Go to Start Menu > Run > Winword or Excel and then press enter key. You can also open it from the usual way from the Start menu > program files. If the program opens, it has no problem with the automation; on the other hand, it has a problem with automation, when it doesn’t open!
How to resolve that? Well to re-register the application that doesn’t open. Say that your Excel application is not opening up then you need to re-register it. To do that, go to Start menu > run > Type “C:Program FilesMicrosoft OfficeOfficeExcel.exe/regserver” without quotes and then hit the enter key! If that doesn’t work, make sure to change the file path of Excel.exe to where you have installed it. Sometimes people may install the office in D: drive or other…
How to Fix Runtime Error 429 by verifying registry entries?
To do that,
- Start menu > Run > type regedit. This will open the Windows Registry Editor!
- Navigate to Registry key -> HKEY_CLASSES_ROOTCLSID.
- Look for the LocalServer32 key; make sure it is using the correct file short path according to DOS 8.3.
- Navigate to HKEY_CLASSES_ROOTCLSID Key, note down the class identifiers code, or CLSID for the Microsoft applications. Since those are associated with ActiveX and OLE 2.0 objects, if they are not correct, Runtime Error 429 will occur. The CLSID for common Microsoft applications are as below,
Program
CLSID
Word
{000209FF-0000–0000-C000-000000000046}
Excel
{00024500–0000-0000-C000-000000000046}
PowerPoint
{91493441-5A91-11CF-8700-00AA0060263B}
Outlook
{0006F03A-0000–0000-C000-000000000046}
Access
{73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9}
The final step in the registry entry troubleshooting is to make sure that you have the correct key. If you had a wrong CLSID in the step 4, and you have changed it to the correct one, this step will teach you to verify that. To do that, go to LocalServer32 key and then paste the code that is between it, on the Start menu > Run, hit enter key. If the respective application belonging to the CLSID code opens up, then your setting are correct. If it doesn’t repeat from step 3 again!
How to Fix Runtime Error 429 by fixing the corrupted Normal.dot or Excel.xlb template file?
You now know that the Runtime Error 429 is caused by the failed automation. The application can also fail to open because of a corrupted Microsoft office template files such as Normal.dot for word, and Excel.xlb for Excel. How to check if the application has only failed to open because of these files? Well, we have another test to run. The first step is to search for these files on your computer and rename them to some other; just appending a character after their name like NormalX.dot is enough! Then go back to the automation test we talked about in the first question at the beginning of this article. Re-run the test again! If the application opens it creates a fresh copy of those files and then will continue to work again, if the application fails to open this time too then there is not problem with these template files; so in that case you need to rename those renamed files back to Normal.dot and Excel.xlb to start using them.
Summary!
The most common reasons for the occurrence of the Runtime Error 429 are the problems with the automation server of the Microsoft office applications. To correct that, you need to re-register all those applications. Then verify the entries found over LocalServer32 under the CLSID key in the windows registry. Also another way is to check for the corrupted Normal.dot and Excel.xlb files, run the rename test and see if its corrupted, if yes, let the application to recreate a fresh copy of them.
The best way to prevent runtime error 429 from occurring again is to invest in a good registry cleaner tool that will fix all the registry issues automatically, so you never need to touch that registry editor again! This will not just solve this runtime error alone but all other errors that can happen because of a corrupted registry entry! A registry cleaner will automatically compact and re-organize your registry when fixing it, which also enhances the performance of your computer! Download a free scan of a registry tool, which we use in our own lab, below this article!
About the Author
Competitive Cyclist Reviews Assos ss.13 Short Sleeve Jersey
|
|
Assos SS.Uno jersey white Large short sleeve – used $69.00 |
|
|
ASSOS JERSEY (Sportline); Campagnolo; Giordana; L; short sleeve; full zipper $0.99 |
|
|
Assos H_FI.UNO s5 Cycling Short XLG Black $20.50 |
|
|
Assos black short sleeved cycling jersey full zip $1.56 |
|
|
New Assos T FI.Uno Logo S5 Bib Short, L-XL $219.95 |
|
|
New Assos T FI.Uno Logo S5 Bib Short, L-XL $219.95 |
|
|
Assos SS13 Short Sleeve Jersey Womens Black Volkanga New with Tags Size Medium $165.00 |
|
|
Assos women’s cycling Short size Small New black $36.11 |
|
|
Bio-Racer Assos Castelli Pearl Izumi Women’s Professional Iris Short $79.95 |
|
|
ASSOS H FI UNO S5 Short – 2011 $145.00 |
|
|
ASSOS H FI UNO S5 Short – 2011 $145.00 |
|
|
ASSOS H FI UNO S5 Short – 2011 $145.00 |
|
|
ASSOS H FI UNO S5 Short – 2011 $145.00 |
|
|
ASSOS H FI UNO S5 Short – 2011 $145.00 |
|
|
ASSOS H FI UNO S5 Short – 2011 $145.00 |
|
|
ASSOS H FI UNO S5 Short – 2011 $145.00 |
|
|
ASSOS H FI UNO S5 Short – 2011 $145.00 |
|
|
Assos short sleeve jersey black size Large – used $99.00 |
|
|
A Short History of Old Fort Niagara … |
|
|
National Education Association of the United States, Addresses and Proceedings of the Ninety-second (Volume 92) Annual Meeting Held At New York City, New York, June 27 – July 2, 1954 “The Ninety-second Annual Meeting and the Thirty-third Representative Assembly of the National Education Association met in New York City, June 27- July 2, 1954. The business of the Association was transacted by 4978 delegates from local and state associations—the largest Assembly in the Association’s history. The theme of the convention was “We hold these truths.” This fitted well into the join… |
|
|
Great American Short Stories … |
|
|
Assos 2012 Men’s T FI.13 S5 Cycling Bib Shorts – Black – 11.10.104.10 AEPD II extreme ergonomic 6-panel race cut/FI.13_S5 insert/innovative insert with ergonomic front and rear cut for less pressure on the genital area. Large high density memory foam. back panel antistatic carbon fiber mesh in klinik color. front panel with perforated high elastic fabric. elastic leg-gripper with asymmetric design. reflective visibility stripes. Packaging: cardboard box with chamois… |
|
|
Assos T Fi.Uno_S5 Bib Short The FI.Uno S5 is not just cycling apparel, but special equipment that enables you to free your mind and go further, longer and faster. Assos’ 6-panel Advanced Ergonomic Pattern Design (A.E.P.D.) delivers an expert, anatomical fit with fewer seams and less irritation. Exclusive A.430 multi-dimensional compression Spandex provides muscle compression and support to increase output and longevity. An a… |
|
|
Assos 2012 Men’s T FI.Mille_S5 longLeg Cycling Bib Shorts – Black – 11.10.102.10 Another revolutionary design by ASSOS! The redesigned FI Mille, with new S5 chamois, is designed to be your ideal long-distance comfort short. Extra cushioned insert and less-restrictive, anatomical, four paneled ASSOS A.E.P.D. (Advanced Ergonomic Pattern Design) results in fewer seams, for the best fit and comfort. More total comfort. More technology. More performance. Engineered for high-perform… |
|
|
Assos Prosline Gloves – Titanium – 2200.2000.6 $54.95 The Pros Glove is a premium racing glove of high quality. They feature: an anatomical shape, terry cloth panel, a Kevlar palm for protection…. |
Tags: assos short, automation server, error, fix runtime error 429, how to fix runtime error 429, microsoft office applications, run, runtime error 429, visual basic script, visual basic scripts