I have an Excel spreadsheet used for timing motorsport events. A macro is triggered by clicking a Button; this macro basically records the current time of day and asks the user to identify the car. The spreadsheet builds up a database of the times that each car passes a certain point. Other macros extract, manipulate and display relevant data about each car's performance. I want to modernise the application by adding a beam to send a signal through a USB (preferably) or other port to trigger the macro to start whenever the beam is broken. Can anyone advise how I should go about making the external signal from the beam trigger my Excel macro to begin? I have not obtained the beam yet as replies to my question may determine the type of beam I need to get.
Can anyone help?
Nick