CommonDialog Error

[Clement]

Hi all,

I trying to add a commondialog control into my VBA form in excel, but it
show an error message "The control could not be created because it is not
properly licensed."

How to solve this problem?

Thanks

Clement

 

[Keith Willshaw]

Hi all,

I trying to add a commondialog control into my VBA form in excel, but it
show an error message "The control could not be created because it is not
properly licensed."

How to solve this problem?

Thanks

Clement

You need either a copy of VB6 or the Developer edition of Office

Only the run-time license for these tools are included in the standard
office distribution. As an alternative use the inbuilt Excel dialogs

Keith

 

[Harald Staff]

Hi Clement

In short; don't do it. For common dialog's Open and Save, use VBA's own
GetOpenFilename and GetSaveAsFilename. The color dialog is of little use in
Excel, and Excel/Windows has their built-in printer dialogs. For a hopefully
working "Save" solution, see my reply to Sayed in this thread.