Pro Tec

No items matching your keywords were found.

Pro Tec
Pro Tec

How to Fix Runtime Error 429 Caused By Automation Server

What are the causes of Run­time Error 429?

When you are try­ing to auto­mate Microsoft office soft­wares such as word or excel using macros or visual basic scripts, Run­time Error 429 occurs! A bet­ter exam­ple is using a Visual basic script to access the data­base infor­ma­tion from Microsoft Access file and that inputting that infor­ma­tion into Microsoft excel file and then using it to com­pute sta­tis­tics or cre­ate a chart from it or what­ever. So what is the other bet­ter way to auto­mate those kinds of oper­a­tions? Well, you can use an automa­tion server that run on win­dows COM archi­tec­ture! So what exactly an automa­tion server does is to allow your office appli­ca­tions to access COM archi­tec­ture as an inde­pen­dent func­tion within the file or as an exe­cutable files that auto­mate tasks.

Ok, let's talk about how the Run­time Error 429 appears on the screen; it goes some­thing like this,

"Run-time error 429 – ActiveX com­po­nent can't cre­ate object"

So, to sum­ma­rize the Run­time Error 429 occurs because if you are try­ing to use Microsoft Visual Basic script to cre­ate a new object func­tion or new oper­a­tor that exe­cutes cer­tain tasks asso­ci­ated with a Microsoft office applications.

How to Fix Run­time Error 429 using an Automa­tion server troubleshooting?

The first step is to make sure you don't have faulty appli­ca­tion setups and con­fig­u­ra­tions. This will make sure that you don't have a server prob­lem.  How to make sure that you don't have a faulty setup? The solu­tion is to find it out. Go to Start Menu > Run > Win­word or Excel and then press enter key. You can also open it from the usual way from the Start menu > pro­gram files. If the pro­gram opens, it has no prob­lem with the automa­tion; on the other hand, it has a prob­lem with automa­tion, when it doesn't open!

How to resolve that? Well to re-register the appli­ca­tion that doesn't open. Say that your Excel appli­ca­tion is not open­ing up then you need to re-register it. To do that, go to Start menu > run > Type "C:Program FilesMicrosoft OfficeOfficeExcel.exe/regserver" with­out 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. Some­times peo­ple may install the office in D: drive or other…

How to Fix Run­time Error 429 by ver­i­fy­ing reg­istry entries?

To do that,

  1. Start menu > Run > type regedit. This will open the Win­dows Reg­istry Editor!
  2. Nav­i­gate to Reg­istry key -> HKEY_CLASSES_ROOTCLSID.
  3. Look for the LocalServer32 key; make sure it is using the cor­rect file short path accord­ing to DOS 8.3.
  4. Nav­i­gate to HKEY_CLASSES_ROOTCLSID Key, note down the class iden­ti­fiers code, or CLSID for the Microsoft appli­ca­tions. Since those are asso­ci­ated with ActiveX and OLE 2.0 objects, if they are not cor­rect, Run­time Error 429 will occur. The CLSID for com­mon Microsoft appli­ca­tions are as below,

Pro­gram

CLSID

Word

{000209FF-0000–0000-C000-000000000046}

Excel

{00024500–0000-0000-C000-000000000046}

Pow­er­Point

{91493441-5A91-11CF-8700-00AA0060263B}

Out­look

{0006F03A-0000–0000-C000-000000000046}

Access

{73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9}

The final step in the reg­istry entry trou­bleshoot­ing is to make sure that you have the cor­rect key. If you had a wrong CLSID in the step 4, and you have changed it to the cor­rect one, this step will teach you to ver­ify 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 respec­tive appli­ca­tion belong­ing to the CLSID code opens up, then your set­ting are cor­rect. If it doesn't repeat from step 3 again!

How to Fix Run­time Error 429 by fix­ing the cor­rupted Normal.dot or Excel.xlb tem­plate file?

You now know that the Run­time Error 429 is caused by the failed automa­tion. The appli­ca­tion can also fail to open because of a cor­rupted Microsoft office tem­plate files such as Normal.dot for word, and Excel.xlb for Excel. How to check if the appli­ca­tion 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 com­puter and rename them to some other; just append­ing a char­ac­ter after their name like NormalX.dot is enough! Then go back to the automa­tion test we talked about in the first ques­tion at the begin­ning of this arti­cle. Re-run the test again! If the appli­ca­tion opens it cre­ates a fresh copy of those files and then will con­tinue to work again, if the appli­ca­tion fails to open this time too then there is not prob­lem with these tem­plate files; so in that case you need to rename those renamed files back to Normal.dot and Excel.xlb to start using them.

Sum­mary!

The most com­mon rea­sons for the occur­rence of the Run­time Error 429 are the prob­lems with the automa­tion server of the Microsoft office appli­ca­tions. To cor­rect that, you need to re-register all those appli­ca­tions. Then ver­ify the entries found over LocalServer32 under the CLSID key in the win­dows reg­istry. Also another way is to check for the cor­rupted Normal.dot and Excel.xlb files, run the rename test and see if its cor­rupted, if yes, let the appli­ca­tion to recre­ate a fresh copy of them.

Note:

The best way to pre­vent run­time error 429 from occur­ring again is to invest in a good reg­istry cleaner tool that will fix all the reg­istry issues auto­mat­i­cally, so you never need to touch that reg­istry edi­tor again! This will not just solve this run­time error alone but all other errors that can hap­pen because of a cor­rupted reg­istry entry! A reg­istry cleaner will auto­mat­i­cally com­pact and re-organize your reg­istry when fix­ing it, which also enhances the per­for­mance of your com­puter! Down­load a free scan of a reg­istry tool, which we use in our own lab, below this article!

 

 

About the Author

Should I Buy Uhlsport Akkurat Absolutgrip Soccer Goalie Gloves or Reusch RAPTOR PRO G1 ORTHO TEC goalie gloves?

I play varsity high school level soccer and I am just wondering what gloves are better. Also a site called epic sports is selling both of these for only 102 when everywhere else they 160 so I am just wondering if its a reliable site?

Reusch RAPTOR PRO G1 ORTHO TEC goalie gloves they are way beeter and cooler!

Ben Raybourn skating the Pro-Tec Pool Party 2010

Tags: , , , , , , , , ,

Comments are closed.