ProjectsContests
Asked by in Circuits
545Views2Replies

Author Options:

edit topicdelete topic

Arduino Control by Excel2000 Answered

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

Tags:excelportnanocontrolmonitor

Comments

The forums are retiring in 2021 and are now closed for new topics and comments.
0
steveastrouk
steveastrouk

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

0
charlie.harris.376
charlie.harris.376

Answer 5 years ago

Hi Steve

Thanks for that will follow up.

Still need info on sending data from Excel to arduino

Thanks

Charles

0
steveastrouk
steveastrouk

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.