serial port data acquisition

[Guest]

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?

 

[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

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?

 

[Thomas Lutz]

You might want to look at a product called WinWedge from TAL
Technologies.
WinWedge is designed specifically for interfacing laboratory
instruments to any other Windows program including Excel.
For more information visit:
http://www.taltech.com/products/winwedge.html