i want to scan an object with an rfid reader and find the item in a list i have in the excel, so i can edit its info in the excel quickly without searching. Is this possible?
i want to scan an object with an rfid reader and find the item in a list i have in the excel, so i can edit its info in the excel quickly without searching. Is this possible?
It depends on a software installed with your RFID reader. BAsically you shall be able to read RF code into worksheet. Once it is there, you can use Range.Find nethod to locate a cell with the RFcode and then .offset method to go to a cell containing item description (probably .offset(0,1) if the description is in column right to item rfcode
Best Regards,
Kaper
So i should contact with rhe rfid reader suppliers and require that the reader has this software?
How the rfid reader is connected with the excel?
Im new to this. Thanks in advance
Readers are usually connected to the computer either via USB cable or via Bluetooth wireless connection. Both cases require some drivers to be installed in the system.
The drivers could be automatically installed if the device is "plug-and-play" type (even if there is no plug and is connected via bluetooth).
And typical rfid reader software would act like a keybord. So after each token reading, if excel is open, the RF code is written in a cell and "Enter is pressed" so the next cell below becomes active.
If you are at this stage, so you can scan tokens and have a list of them in a column, we could help with some VBA code to search this code in other parts of document.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks