View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Receive data from barcode reader in VBA

The bar code reader would be connected to the PC through some port like a USB
or RS232 serial port. Excel would have to control the port by putting the
device into scan mode and then read data from the port.

I've programmed Rs-232 serial ports on the PC through VBA. You need to get
the list of commands the bar code reader supports and generate a program.
Many device supply sample code. Check the bar code manuafactures website for
downloads and sample code.

"Ken" wrote:

I was wondering if there was a way to receive a scan from a barcode reader
and move down one cell.
I'm hoping its possible to have vba select the cell, go into edit mode
recieve scan, enter and then move down one cell.
I guess it would be a matter of programatically going into and out of edit
mode based on length of the variable.