545Views2Replies
Arduino Control by Excel2000
Hi
Is it possible to send single character data from MS Excel2000, to the Arduino monitor, which will ,via the usb send on to the Arduino device. (say turning leds on and off.) Low volume of data, 10 characters minute.
That is within VBA of the Excel to send the data from Excel to appear in Arduino monitor and thru USB to Arduino Nano where it will be dealt with by other arduino sketch.
I will need to know what vba to use in Excel and what code required in sketch to accept vba.
Thanks
CharlesHarris
Comments
5 years ago
Yes, it appears to be possible. Its discussed in many forums. This relates to receiving data
http://www.mrexcel.com/forum/excel-questions/488335-receive-data-com-port.html
Answer 5 years ago
Hi Steve
Thanks for that will follow up.
Still need info on sending data from Excel to arduino
Thanks
Charles
Answer 5 years ago
The process described uses the GET construction
Get #COM5file, , record
Try the
Set #COM5file, , record
instead. Set record = your character to transmit.