Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Using a Bar Code Reader to Enter Data (97 and >)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Loungers

    Can anyone, having experience with using bar codes, tell me if I can attach a Bar Code Reader to enter data into ME-Excel, 97 and newer?

    I need a user to be able to scan in a bar code, and the information from this bar code can be placed in cells on a worksheet.

    Say I am developing a membership application, when a member comes by to the club, his membership card's bar code will be scanned and his info, name, address, expiration date, entered into the worksheet.

    I searched the MSKB, and although this sounds like a good idea, there are no articles.

    Thanks

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using a Bar Code Reader to Enter Data (97 and >)

    I have never used a reader with excel, however I am familiar with their operation.

    basically the barcode reader is a keyboard wedge. That is it will pass a string as if it was entered by the keyboard.

    What you will need to determine however is the terminating character that the barcode reader will append to the end of the string. It is normally a tab or an carriage return, however most of the readers allow you to customise this.
    Amending this character will allow you to fire events as the cell/form field is completed by the barcode reader, ie do lookups etc as your application outline suggests.

    The barcode reader firmware should automatically remove the start/stop characters and checksum that is embedded into the barcode.

    Also beware of the different fonts used by barcode readers, some are free, some are not widely available etc and it pays to reseach the long term costs of this choice.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using a Bar Code Reader to Enter Data (97 and >)

    If the bar code readers sends data just like it came from the keyboard, and if Excel is the active window, then whatever is scanned would just be put into the active cell. If the reader attaches to another port, like the COM: port, then it would require VBA code.
    Legare Coleman

Posting Permissions

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