Excel 2016 real time data link

I have successfully made a closed loop speed feedback system for my N gauge train using hall effect sensors.

What I what to do now is record the events in an Excel based spreadsheet.

I can get the Arduino to read out to the USB but how ca I get the Excel to see the USB event and read in the data.

Has anyone got any hints for 2016 VBA


If you have problems with VBA for Office 2016, you are asking on the wrong forum. Microsoft's forum for Excel developers would be the more useful place.