What is the best way to access a serial port from VBA?
The Win32 API handles the serial port as a file. You can access the serial ports directly by calling these API functions from within VBA. I had to do this for an old .NET application but VBA is no different. Rather than hash it out for you on this site, here’s a reference I’ve hung … Read more