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

"Clement" wrote in message
...
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

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.

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Clement" skrev i melding
...
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