Excel does not come with the MSComm ActiveX control- it is provided
with Visual Studio 6. If you have it on your system but do not have
Visual Studio 6 installed, it also will not work because you do not
have a license to use it.

The easiest way to get serial data into an Excel spreadsheet would be
to use a 3rd party tool like WinWedge from TALtech.
WinWedge is an executable program that runs in the background and
feeds serial data directly to other programs either by stuffing the
keyboard buffer or by passing the data to other programs using Dynamic
Data Exchange (DDE). It also supports sending data out a serial port
as well.
For more information about WinWedge please visit:
http://www.taltech.com/products/winwedge.html


On Wed, 6 Oct 2004 18:54:24 -0700, "Wal"
wrote:

Is it possible to use VBA read and write to a serial port
for use in/from Excel?
Where can I look at sample code to learn how it is done?