To write VBA code in Excel to do serial I/O functions would be
extremely difficult. Your best bet is to use a tool that is designed
for the job. One product that you might look at is called WinWedge
from TAL Technologies. WinWedge is an executable program that is
designed to run in the background and feed incoming serial data
directly to other programs as well as send data out a serial port from
other programs. It is typically used to interface all sorts of
instruments directly to an Excel spreadsheet.
For more complete information visit:
http://www.taltech.com/products/winwedge.html


On Thu, 19 May 2005 12:49:02 -0700, "How can I Read Serial Data" <How
can I Read Serial wrote:

How can I use Visual basic in Excel to Read serial data from an external
device.