Connection with a serial interface

[schneider]

Hello,

I have data's stored by a microcontroller. I can use a RS232 connection
to take the data and store them on my computer for further treatment
with excel.

I try to find some solution to do that directly from excel (instead of
hyperterminal and then excel).
Is that possible ?

Thanks you for your help,
Jean-Marie

 

[joel]

Private Sub ReadPort_UIButton_Click()
Dim temp As String
Open "com1:" For Input As #1 Len = 3
Input #1, temp ' This line hangs
Close #1
End Sub


See webpage below

'Serial I/O (RS232)' (http://mc-computing.com/languages/serialio.htm)