| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading Comm Port in Excel
Is there any to read data from the Comm port in Excel? Right now I'm using
another program to read the serial port and save the data to a text file. Then I import the text file into Excel. There must be an easier way using just Excel. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reading Comm Port in Excel
I have had success using MSComm32.ocx and VBA - I just can't find that file right now. Anyway, an
example: http://www.pencomdesign.com/support/...re_example.htm HTH, Bernie MS Excel MVP "SA" wrote in message ... Is there any to read data from the Comm port in Excel? Right now I'm using another program to read the serial port and save the data to a text file. Then I import the text file into Excel. There must be an easier way using just Excel. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reading Comm Port in Excel
Close All
Open "Com1:" for Output as #1 Write #1, "ABC" or Open "Com1:" for Input as #2 Input #2, MyVar "SA" wrote: Is there any to read data from the Comm port in Excel? Right now I'm using another program to read the serial port and save the data to a text file. Then I import the text file into Excel. There must be an easier way using just Excel. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Send a query and receive data through a Comm Port | Excel Programming | |||
| reading data from com port into 2 different cell locations. | Excel Programming | |||
| reading data from com port into excel spreadsheet | Excel Programming | |||
| Can I use serial comm port in Excel VB script? | Excel Programming | |||
| Reading the pin voltage fm RS232 port into excel by using VBA | Excel Programming | |||
Hybrid Mode
