ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Serial port interface (https://www.excelbanter.com/excel-programming/312216-serial-port-interface.html)

TAV

Serial port interface
 
I would like to take data from a device connected to the RS232 port and
import it directly to an Excel spreadsheet. Does anyone know the best way
to accomplish this?

Greg Koppel

Serial port interface
 
Use the shell() function and a QBASIC program.

HTH, Greg

"TAV" wrote in message
...
I would like to take data from a device connected to the RS232 port and
import it directly to an Excel spreadsheet. Does anyone know the best way
to accomplish this?



Thomas Lutz

Serial port interface
 
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 Fri, 1 Oct 2004 13:06:24 -0700, "TAV"
wrote:

I would like to take data from a device connected to the RS232 port and
import it directly to an Excel spreadsheet. Does anyone know the best way
to accomplish this?




All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com