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.