"ActiveX component can't create object" error message when you run code that calls the Common Dialog Control (Comdlg32.ocx) (281848)

The information in this article applies to:

Microsoft Project 2000
Microsoft Excel 2000
Microsoft Access 2000
Microsoft Word 2000
Microsoft Outlook 2000
Microsoft PowerPoint 2000
Microsoft Visio 2000 Standard Edition

This article was previously published under Q281848

SYMPTOMS

When you run code that calls the Common Dialog Control (Comdlg32.ocx) on a computer other than the one where the code was developed, you may receive the following error message:

Run-time error 429: ActiveX component can't create object.

CAUSE

This problem can occur if the following conditions are true:

The control is called from Visual Basic for Applications code by using the New CommonDialog command.
The computer from where you are running the code has a run-time license instead of a design-time license for this control.

With a run-time license, you can load the control, but you cannot create or insert it. The design-time license for this control is included with the Microsoft Office 2000 Developer Edition, Microsoft Visual Basic 6.0, and Microsoft Visual Studio. It is not included with other versions of Microsoft Office 2000.

WORKAROUND

To work around this problem, wrap the control inside another control, such as a UserForm. To do this, follow these steps:

In the Visual Basic Editor, add a UserForm to your project.
Insert a common dialog control on the UserForm. For example, use the following code to call the common dialog control on the UserForm:
```
   Sub test()
     UserForm1.CommonDialog1.ShowOpen
   End Sub
					
```
Save the workbook.

Because the control is wrapped in the UserForm and it resides inside the project, you can now call it in run-time mode.

Modification Type:	Minor	Last Reviewed:	10/11/2006
Keywords:	kbProgramming kbtshoot kbdtacode kberrmsg kbprb KB281848