MsComm32.ocx need Licensed in vba.

Hi.

I try to word with MsComm32.ocx in Excel - Vba.
I could insert form to excel, and could to add
  the control to toolbox with References -> Browse...
  but, when i try to add the control to the form,
  i get this ugly message :

  'The control could not be created because it is not
   property licensed.'

This is not happen with computer with Visual Basic.
  but i need to work with this control on computer
  that not have Visual Basic.

Please, try to help me.
Alon.
 
Alon1001Asked:
Who is Participating?
 
Ryan ChongConnect With a Mentor Commented:
Hi Alon1001,

try to register your MsComm32.ocx to your System folder before?

You can try this:

regsvr32 C:\Winnt\system32\Mscomct2.ocx 'For NT/2000

regsvr32 C:\Windows\system\Mscomct2.ocx 'For WinX

regards.
0
 
dekeldateCommented:
You could try putting a valid MsComm32.ocx on the other machine by making a small program with the 'Comm Control', compilling it, creating a setup and instaling it on the other machine. This should install it correctly with all licences.

example
1.start a new project.
  make it an exe if you do not wany to write any code in it
2.give the project a reasonable name (e.g. addComm)
3.add the Microsoft Comm Control (Project -> components)
4.add the Comm control to the form (you might not need this step)
5.Compile the project (File -> Make addComm.exe)
6.If the Package and Deployment wizard is not available in the Add-Ins Menu then (Add-ns -> Add-Ins Manager... double click 'ackage and Deployment wizard' click 'K')
7.run the Package and Deployment wizard (Add-Ins - > Package and Deployment wizard) follow ithe instrutions.
8 Once completed install the package on the other machine/

Note: although this does not install VB on the other machine, it does install the VB Runtime files. If this is fine the above solution should make the MsComm32.ocx available to Word and Excel on the other machine.
0
 
Alon1001Author Commented:
Mscomm32.ocx not mscomct2.ocx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.