CommonDialog Error

  • Thread starter Thread starter Clement
  • Start date Start date
C

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
 
Clement said:
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
Click to expand...

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.
 
Back
Top