Hi, i'm new, i must to acquire a data directly to excel by the serial port
i must to put a menù for choose the seial port address com1 to com 8

from the serial port com i's arriving every 10 seconds a string like this:

#000006081008143350..C.LUy@
#000004081008143400....LUy@

the string always start by # and finish by @

in excel i must do a macro that put the data that arrive from the com , like this:

first string A1 cell
second string A2 cell
third string A3 cell
.....

i's possible to use mscomm ?

how can i do i'm not very expert to use Visual Basic
thanks everyone Who help me !
bye