Receive data from barcode reader in VBA

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

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.
 
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.
 
Its USB, Thanks for the help I'll look into it.

Joel said:
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.
Click to expand...
 
Back
Top