Control not properly licensed???

Hi,
I am working on an Excel Macro with a form. I decided to add the Openfile feature from the commondialog control. To my surprise, placing the commondialog box from the ToolBox onto my form causes this error message:

"The control could not be created because it is not properly licensed"

Please advise.

PhiL

I receive the following error as well "License Information for this component not found. You do not have the appropriate license o use this functionaliy in the design envorinment".

Anyone have any words on this???

Ryan

rheyman

I figured out how it's done. I was told you don't use the components on VB Excel as you would in VB6. Here is my code to use the commondialog function without the CommonDialog component.

Code:

---

Private Sub CommandButton3_Click()
 CommandButton1.SetFocus
 form1.TextBox1.Text = Application.GetOpenFilename("MS Excel (*.xls), *.xls", , "Open the Excel (.xls) exported from MS Access")
End Sub

---

I tried it but it told me that an Object Was required. I'm in VB 5 anyway.... I posted a reply to your thread because I was received the same error. MY problem is that I'm opening an external file using the Shell command and I'm trying to makeup a way to point to the file so it's not hard scripted.

My program runs a Doom 3 console and right now I only have i set to call "C:\Program Files\Doom 3\doom3.exe" I would like my users to be able to imput any path to the file. So, to be able to select a ChDrive and ChDir command.