Hey everyone, I'm hoping you can help me out. I've been having a tough time finding a method of recording RS232 data from a laser gun directly into Excel. So far, I've been able to create a HTML script (see attached code) that acts as a buffer between the serial port driver and Excel, but I want to be able to distribute one spreadsheet to my districts for easy traffic studies.
What I have right now is simple for me, but most of the people that will be using this are barely able to use Excel, so it has to be simple. Opening a webpage, then activating the ActiveX control, then opening the Excel file is honestly too complex for some of these folks. If there is a method to opening one Excel file with a macro that can do what I want, I'd really like to know... Thanks in advance!
What I have right now is simple for me, but most of the people that will be using this are barely able to use Excel, so it has to be simple. Opening a webpage, then activating the ActiveX control, then opening the Excel file is honestly too complex for some of these folks. If there is a method to opening one Excel file with a macro that can do what I want, I'd really like to know... Thanks in advance!
Facebook
Twitter