I'm new to the Arduino although I have dabbled with other microcomputers in the past. I'm also reasonably experienced with Excel VBA.
I want to develop an Excel Form that will interact with the Arduino. ie I want to be able to receive data and send data to/from the Arduino and the Excel form.
I have successfully used the Open "Com4: 9600" for binary access read write as #1 and been able to accept data from a number of devices (eg the ultrasonic distance sensor and the temp/humidity sensor). The problem i am having is sometimes the link breaks and the Input(1,,#1) will hang if there is no input. this crashes Excel as even ctrl/break doesn't work. I'm also having to write my own code to construct a line of input 1 character at a time (not too difficult but there must be a better way).
I've tried looking for a more elegant method but everything seems to be unsupported anymore (eg PLX-DAQ, mscomm32) or just doesn't work (eg MSCOMM32 can't be trusted so VBA wont let me put it on the form).
I can't believe this requirement (to enable a robust dialogue between Excel VBA and an Arduino) is not a common one and that it hasn't been cracked already, so if it has can someone tell me the best current solution.
I'm using Excel as part of Office 2013.