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.

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.

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.