You are currently offline, waiting for your internet to reconnect

Your browser is out-of-date

You need to update your browser to use the site.

Update to the latest version of Internet Explorer

} - {url}" print-caption="Print" title="You receive run-time error 429 when you automate Office applications" class="ng-scope ng-isolate-scope">

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

For a Microsoft Office XP, Office 2000, and Office 97 version of this article, see 244264.
Summary
When you use the New operator or the CreateObject function in Microsoft Visual Basic to create an instance of a Microsoft Office application, you may receive the following error message:
Run-time error '429': ActiveX component can't create object
This error occurs when the Component Object Model (COM) cannot create the requested Automation object, and the Automation object is therefore unavailable to Visual Basic. This error does not occur on all computers.

This article describes how to diagnose and resolve common problems that may cause this error.
More information
In Visual Basic, there are several causes of error 429. The error occurs any of the following conditions is true: To find the cause of the error, isolate the problem. If you receive error 429 on a client computer, use the following information to isolate and to resolve the error in Microsoft Office applications.

Note Some of the following information may also apply to non-Office COM servers. However, this article assumes that you want to automate Office applications.

Examine the code

Before you troubleshoot the error, try to isolate a single line of code that may be causing the problem.

If you discover that a single line of code may be causing the problem, complete these procedures:

Examine the automation server

The most common reason for an error to occur with CreateObject or with New is a problem with the server application. Typically, the configuration of the application or the setup of the application causes the problem. To troubleshoot, use following procedures:

Examine the system

System configuration may also cause problems with the out-of-process COM servers creation. To troubleshoot, use the following procedures on the system where the error occurs:

Reinstall Office

If none of the previous procedures resolve the problem, remove Office and then reinstall Office. Microsoft recommends that you remove the existing version first, and then reinstall Office by using the original installation disks.

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
219423 How to remove the Office 2000 CD1
158658 How to completely remove Microsoft Office 97
References
For more information about troubleshooting the '429' error message, click the following article number to view the article in the Microsoft Knowledge Base:
240377 How to ensure Jet 3.5 is installed correctly (part I)
For more information about Office automation and code samples, visit the following Microsoft Web site:
http://support.microsoft.com/ofd
ACC2007 XL2007 SPD2007 WD2007 OL2007 PPT2007
Properties

Article ID: 828550 - Last Review: 07/12/2013 07:56:00 - Revision: 5.6

  • Microsoft Office Excel 2007
  • Microsoft Office SharePoint Designer 2007
  • Microsoft Office Outlook 2007
  • Microsoft Office Outlook 2003
  • Microsoft Office PowerPoint 2007
  • Microsoft Office PowerPoint 2003
  • Microsoft Office Word 2007
  • Microsoft Office Access 2007
  • Microsoft Office Access 2003
  • Microsoft Visual Basic 5.0 Enterprise Edition
  • Microsoft Visual Basic 6.0 Professional Edition
  • Microsoft Visual Basic 5.0 Professional Edition
  • kbexpertisebeginner kbtshoot kbprogramming kberrmsg kbautomation kbinfo KB828550
Feedback