+ Reply to Thread
Results 1 to 4 of 4

RFID Tag - search object in excel

  1. #1
    Registered User
    Join Date
    09-03-2024
    Location
    Athens. Greece
    MS-Off Ver
    MS 365 apps for enterprise
    Posts
    2

    RFID Tag - search object in excel

    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?

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: RFID Tag - search object in excel

    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

  3. #3
    Registered User
    Join Date
    09-03-2024
    Location
    Athens. Greece
    MS-Off Ver
    MS 365 apps for enterprise
    Posts
    2
    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

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: RFID Tag - search object in excel

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 09-03-2024, 06:11 AM
  2. Student attendance tracking RFID
    By yvautrin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2020, 10:44 AM
  3. RFID reader only take the first digi (Excel) vba
    By Vibov in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-06-2018, 11:39 AM
  4. Lock a worksheet, but let rfid scanner write in it
    By HereComesTheBoom in forum Excel General
    Replies: 2
    Last Post: 12-14-2017, 11:46 AM
  5. RFID card data base
    By Ross85 in forum Excel General
    Replies: 2
    Last Post: 09-28-2017, 08:50 PM
  6. Excel to read RFID scanner COM Port and look up for database
    By aeonfulx in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2016, 09:34 AM
  7. RFID Time and date stamp on scan
    By surfershort in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-27-2014, 02:57 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1