Receive data from barcode reader in VBA

[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.

 

[Joel]

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]

Its USB, Thanks for the help I'll look into it.

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.