Capturing data from a serial port.

[mcgj]

We have a device that we are trying to capture a string of delimited text
data from hooked to our computer's serial port. It is sending the data once
per second. Does anyone know how to take control of this port and use the
data in VBA?

I think I can handle getting the data into a useable form once we have it
from the port. Getting it from the port is what has me baffled...

Thanks for your help.

 

[Douglas J Steele]

Tony Toews has some information on this topic at
http://www.granite.ab.ca/access/serialport.htm