ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Connection with a serial interface (https://www.excelbanter.com/excel-programming/441542-connection-serial-interface.html)

schneider

Connection with a serial interface
 
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[_882_]

Connection with a serial interface
 

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)


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194704

http://www.thecodecage.com/forumz



All times are GMT +1. The time now is 07:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com