jl1cny:
Thank you very much for providing a great handy tool to transfer serial data to Excel. I am writing a sketch that controls Arduino by sending characters and numbers to it through serial. I am wondering if you can add functions to PLQ-DAQ version 2 that allows the user to send characters and numbers to Arduino through serial.
(...)
Thank you in advance for your consideration.
Hi Sam,
thanks a lot for your feedback Good news for you: the function is in fact already present in the program
With the command
Serial.println("CELL,GET,D1,");
your Ardunio can ask Excel to send him the values from cell D1 (well in this case). In that cell (and further cells) you could put the variables that you use to operate the frequency range.
Otherwise you could use the custom dev-point "CustomDevPointNewData". There you could easily send your own defined commands from Arduino to Excel and programm in VBA any behaviour you want (e.g. check current time of PC and adjust frequency if time is pre 12:00 am or past 12:00 am. Data can be send to your Arduino from VBA via command
CommWrite cboPort.Text, "Any information can be send here"
In case you have any further questions please feel free to ask
Greetings
NetDevil