I have written the code necessary for my user form to place data from my text fields into the excel sheet where I want it, but I have to use a piece of third party software to open the com port connection to my reader/scanner and place the data in my text fields. I am a novice with VBA and am not familiar with com port communication code. I've searched and searched for something that will let me just receive from the com port when some data is sent, but I can't get anything I've found to work. Here is what I'm working with:
I have an RFID scanner connected to COM 4 through a USB-to-Serial Bridge
My scanner can send a 15-character number, and a date/time separated by tabs
My device operates with: 9600 baud, 8-bits, no parity, 1 stop bit, RTS/CTS flow control
I do not need to write to the com port, only receive the data when an RFID is scanned. I would like to open communication with the port to receive data on TextField Enter.
Can someone please help me with this. If I could just get some code that will let me receive from the port and place the data in a cell on the sheet, I could take it from there. Thanks for the help.
I have an RFID scanner connected to COM 4 through a USB-to-Serial Bridge
My scanner can send a 15-character number, and a date/time separated by tabs
My device operates with: 9600 baud, 8-bits, no parity, 1 stop bit, RTS/CTS flow control
I do not need to write to the com port, only receive the data when an RFID is scanned. I would like to open communication with the port to receive data on TextField Enter.
Can someone please help me with this. If I could just get some code that will let me receive from the port and place the data in a cell on the sheet, I could take it from there. Thanks for the help.
