MSCOMM Control in Excel 2003 / 2007

[tomcee]

Is the MSCOMM control still available in Excel 2003 and 2007?

I see little published about it here lately.

My application is a simple RX / TX monitor with no hardware
handshaking.

If anyone can share code/experiences I would appreciate it.

Regards,
TomC

 

[tomcee]

You can still use in XP below.  Not sure about vista.

Open "com1" For Input As #1

Most people are using network connections over IP which are much
faster.  Most PC these days don't even have serial ports or printer
ports.  You can even use your USB ports for communications.

Thanks Joel.

My application is communication with a simple embedded system which
has only a RS232 port. Thus, it certainly does not have TCP IP. USB
communications with embedded systems is considerably more complex than
RS232, and in most cases impossible as the supplier of the USB
interface circuit must supply the relevant drivers. I am using a USB
to serial convertor on a WinXP system.

As RS232 is a simple, non-supplier specific, all small / embedded
systems support it at a very elemental level.

Thanks again and regards,
TomC

 

[Peter T]

The control should still be available although it wont work in 2010 64bit

Can put in on a sheet or form, in the ActiveX controls toolbox toolbar or
Userform's toolbox, add as an additional control "Microsoft Winsock
control".

If you get a security message when adding it to the form or sheet, or it
doesn't appear, see this link and get the update (your users will need to do
same)

http://support.microsoft.com/kb/827742

Regards,
Peter T