If you are trying to show the fileopen/saveas dialogs use
application.GetOpenfileName
and/or
Application.GetSaveAsFilename

see excel vba help for details.

--
Regards,
Tom Ogilvy

Michael Xu wrote in message
...
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 notproperly licensed." I
have installed Microsoft Office Xp(sp2) and Microsoft Visual Studio.net
2002,
and my platform is Microsoft Windows Server 2000 (sp4) . I have tried
unregister comdlg32.ocx and register it again,but it did not take effect.
How can I resolve this problem ,thanks !