serial port data acquisition

J

jgseas

I have a laboratory instrument that connects to the serial port of my PC. Is it possible to program Excel to collect the data coming into the serial port and plot it in real time? How do I get started with this?
 
B

Bernie Deitrick

jgseas,

If you have the Microsoft Communications Control (MSComm32.OCX) you can
add it to a userform and then can capture data from a serial port.

HTH,
Bernie
MS Excel MVP

jgseas said:
I have a laboratory instrument that connects to the serial port of my PC.
Is it possible to program Excel to collect the data coming into the serial
port and plot it in real time? How do I get started with this?
 
Top