Managing Arduino with Excel

Good day. Yesterday a very interesting post was posted on the FLProg program forum by user Rw6cm . I decided that the information from it might be interesting to a wider circle of people, so I published the project description from the author here (the author does not have an account on Geektimes).

An example of how to manage Arduino from Excel and retrieve data.
Information may be useful to Excel supporters and those who know the basics of VBA.
The example is implemented in FLProg 1.10.5 on Windows7 - 32 and 64, and MsOffice 2007.
Everything you need to repeat it is in the archive.
As an example, we took the DS18B20 sensor, which, following a command from Excel via ComPort, with arduino uno transmits temperature data every 5 seconds to Excel, and it builds an OnLine graph in it.


')
On the Arduino side, temperature monitoring and Excel commands are displayed.



FLProg schema is not difficult to understand and repeat.



On the Excel side, the program is written in VBA using the MSCOMM32 SmallX ActiveX.
Library and installation help inside.

Important!!!

The ActiveX element is MSComm ancient, and works with COM ports 1 through 16.
If your device is determined with a large number, change it in the driver properties.

The assembly is simple, connect the arduino to your cable,
open the project, put your address sensor Ds18b20, fill.
Run the excel file, allow macros to work in it, prescribe the Com number of the arduino port,
Click "Start" ... and enjoy.
Who wants to dig into the code, password 123
Go ahead !!!

Source archive