Vba For Excel Serial Communication With Arduino Microcontroller

Code: Private Sub CommandButton1_Click() ' Buffer to hold input string Dim Instring As String ' Use COM13 MSComm1.CommPort = 13 ' 9600 baud, no parity, 8 data, and 1 stop bit. MSComm1.Settings = '9600,N,8,1' ' Tell the control to read entire buffer when Input ' is used. MSComm1.InputLen = 0 ' Open the port. MSComm1.PortOpen = True ' Send the data to the port data = TextBox1.Text ' The brightness required, 0-255 Debug.Print 'Data=' & data ' Send the data to the Arduino. MSComm1.Output = data & vbCrLf ' Close the Port MSComm1.PortOpen = False End Sub Any thoughts?

Sending Serial Data from Excel? The scripting language is called Visual Basic for Applications. I think this is an great way to log the data coming from my Arduino. Real time online push button based counting system. Ask Question -1. I am doing this project. The data arriving through serial communication should be transferred to an excel sheet/database. Browse other questions tagged excel-vba serial-port arduino microcontroller avr-gcc or ask your own question. 3 years, 10 months ago.

Lingvisticheskaya skazka pro mestoimenie 2. Moderator edit: [code] [/code] tags added.