RS232 serial port data to Excel table

[wartburg]

Dear All,

I have fought for some days with the following problem:

I have an old-but-lovely measuring device being able to send results to its serial port.
I can receive the data from serial port with the following setting:

native COM1 port
baudrate: 9600
8 bit / 1 stop bit
no parity

As Win 7 no more contains hyperterminal application, I tested my serial port by using a third party software (Eltima Serial Port Monitor). It works correctly, the data can be shown on the monitoring window and can also be saved into a txt file.

The data row looks like the following:

AT&F&C1&D2S0=0&K3M0
1
1
.100
. 3.3638790
. 3.3591828
. 3.3547211
.
. (approx. 4000 number in a row)
.
.
.

. 8059.5000000
. 8107.2500000
. 8159.5000000
.
.
.DATE: 12-16-2015


So there are a lot of numbers (approx. 4000...4500) from 1 to 7 decimals and some text lines.
Each data represent a line.

Can somebody help me to make this VB macro?
I use Excel 2010
Thanks in advance

Mary-Lou

 

[RickXL]

Hi and welcome to the MrExcel Message Board.

Are you looking for a macro that will read in the text file and write it to a worksheet - or something else?