View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How do I insert barcodes from a scanner into Excel cells?

Most barcode scanners have a utility that reads the bar code, then transmits
the code as emulated keystrokes, terminated with a carriage return. These
work well with excel.

--
Regards,
Tom Ogilvy

"Technotrepid" wrote in message
...
I want to create a database of books based on the ISBN coding on the
jacket.
It would be great if the process was semi-automatic using a macro to
quicken
the entry procedure but allow a pause to enter title, author, etc.

Is there an easy way of capturing the barcode from a scanner and
automatically inserting those values directly into Excel cells?