Automatically filling cell with data from COM port

[William Loring]

Is it possible to write a script for Excel that will automatically populate
a cell with data received from the COM port?

I have a timer which sends timing data to the COM port (as ascii text) via a
serial cable, and would like to have these times automatically inserted into
a cell in an excel spreadsheet.

Any help would be greatly appreciated.


Regards,

William Loring
The Tire Rack

 

[jaf]

http://www.google.com/groups?as_q=r...&oe=UTF-8&as_ugroup=*excel*&lr=&num=100&hl=en


--
John
johnf 202 at hotmail dot com


| Is it possible to write a script for Excel that will automatically populate
| a cell with data received from the COM port?
|
| I have a timer which sends timing data to the COM port (as ascii text) via a
| serial cable, and would like to have these times automatically inserted into
| a cell in an excel spreadsheet.
|
| Any help would be greatly appreciated.
|
|
| Regards,
|
| William Loring
| The Tire Rack
|

 

[Thomas Lutz]

Excel makes it extremely difficult to do serial communications. You
would need to write some very complex code calling Windows API
functions in order to do serial I/O. You may be able to use a serial
communications ActiveX control however you would still need to write
quite a bit of code to get it to work the way you require.
If you want to read in simple text strings directly into Excel, then
almost certainly the easiest thing to do would be to get a tool that
is designed specifically for the job.
I would recommend that you take a look at a product called WinWedge
at:
http://www.taltech.com/products/winwedge.html
The Standard Edition of WinWedge should do everything that you need
and it should have you up and running very quickly with litle or no
code required.