"ActiveX component can't create object" error message when you run code that calls the Common Dialog Control (Comdlg32.ocx)
This article was previously published under Q281848
This article has been archived. It is offered "as is" and will no longer be updated.
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.
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.
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.
XL2000 OFF2000 WD2000 OL2000 PPT2000
Article ID: 281848 - Last Review: 12/05/2015 23:11:13 - Revision: 4.3
Microsoft Project 2000 Standard Edition, Microsoft Excel 2000 Standard Edition, Microsoft Access 2000 Standard Edition, Microsoft Word 2000 Standard Edition, Microsoft Outlook 2000 Standard Edition, Microsoft PowerPoint 2000 Standard Edition, Microsoft Visio 2000 Standard Edition
- kbnosurvey kbarchive kbprogramming kbtshoot kbdtacode kberrmsg kbprb KB281848