Com Port and VBA from Excel

[f.decultieux]

Hi,

I am trying to program communication through the COM ports
by using VBA from Excel.
The problem is that I do not have the MSCOMM32.OCX ActiveX
component available for that purpose (it is available with
Visual Basic but I did not get it with VBA).
Is there any way to get it available for programming with
VBA without using the one from Visual Basic 6 ?

Thanks,

Florent

 

[jaf]

Hi Florent,
You can get a copy here.
See this http://www.yes-tele.com/mscomm.html

 

[Thomas Lutz]

The MSComm control is a licensed control so you need a license from
Microsoft to use it in an application. You can download the control
from many places on the Internet including the Microsoft web site
however if you do not install Visual Basic, you will not get the
license for the control so that you will be able to use it.

There are other ActiveX controls available that you can purchase like
the Sax COM Objects :http://www.sax.net/Default.aspx

You might also want to investigate a product called WinWedge from TAL
Technologies at:
http://www.taltech.com/products/winwedge.html
WinWedge is not an ActiveX control however it is an excellent tool for
doing serial communications from within Excel. It is also much easier
to use than an ActiveX control. In most cases you do not need to write
any code at all in VBA.