I need to create a button in Excel to read data in from serial port. I can't have any extra files attached to the excel sheet. I need to transfer this excel file to another computer to read this data.Here is how the file is suppose to function: Press button to select the serial port. Then, press another button to read data from serial port into the excel cell.Could someone please tell me how to do this? Use VB macro or ActiveX macro?
![](/uploads/1/2/6/6/126637523/797149381.png)
![Vba For Excel Serial Communication With Arduino Download Vba For Excel Serial Communication With Arduino Download](/uploads/1/2/6/6/126637523/550619154.png)
![Vba For Excel Serial Communication With Arduino Download Vba For Excel Serial Communication With Arduino Download](/uploads/1/2/6/6/126637523/176849907.png)
In case of receiving a data from the serial port 'save' in excel the data together with the time and date. Thanks to all in advance. Arduino Excel Download Any.
Sorry, this is the first time i'm using excel for this. Again, I can't have another file attached to the excel sheet.
I found a discussion on exactly this topic in the german microcontroler.net forum here:Since I am running on Linux I can not verify if the code is correct.
![](/uploads/1/2/6/6/126637523/797149381.png)