Excel to inport data

[Danny]

Excel to inport data via the Com port 1

 

[joel]

I think you'll need a macro. Not sure need more details. Where is the data
coming from. If possible it would be easier to read a file. The prblem with
the serial port you usally need to send commands to the device on the serial
port before the data is downloaded. You can inport data into a file by going
to DOS and create a file in DOS.

From the Start menu select RUN. Then type in Run box cmd.exe.

Now a Dos window will appear.

the type the following

copy com1: >abc.txt

Download your file. When done kill the DOS window to stop the transfer.
Now you data will be in the text file.