I have seen Microsoft Visual Basic applications receive and transmit serial
data through the serial port, managed by the Object/Procedure Private Sub
MSComm1_OnComm(). The serial port parameters are set with the other Form
properties, and my question is: Can something similar be done using Excel?

Initially, I intend to monitor incoming serial data, either in a messagebox,
or a spreadsheet cell, and then develop code to analyse this information in
real time. I have searched the Excel help fles for MSComm1, but have not
found any references to serial communication. Has anyone used the serial
ports with Excel, and if so, could they point me towards relevant background
information, or examples.

In hope..... which has so far not been disappointed......

Hi,
If you have the mscomm32.ocx on your system you can use it the same as in
VB.
Open a form. Right click on the toolbox, select additional controls and
choose mscomm32.



--

John

johnf202 at hotmail dot com


"Hotbird" wrote in message
...
I have seen Microsoft Visual Basic applications receive and transmit
serial
data through the serial port, managed by the Object/Procedure Private Sub
MSComm1_OnComm(). The serial port parameters are set with the other Form
properties, and my question is: Can something similar be done using
Excel?

Initially, I intend to monitor incoming serial data, either in a
messagebox,
or a spreadsheet cell, and then develop code to analyse this information
in
real time. I have searched the Excel help fles for MSComm1, but have not
found any references to serial communication. Has anyone used the serial
ports with Excel, and if so, could they point me towards relevant
background
information, or examples.

In hope..... which has so far not been disappointed......