Bar code Scaner

[DDavid]

Hi all,

I have a bar code scanner but when I read a bar code and it writes the
number to a cell I want it to go to the next cell (like hit enter). it
reads a 16 number barcode.

thanks

 

[JW]

Need to see the code to offer more advice, but Offset should be what
you need.
ActiveCell.Offset(1,0).Select will select the cell below the currently
active cell.

 

[DDavid]

it is a hand barcode scanner, the barcode (in lines)
736125605D17245322 (cell A1)
736125605D17245323 (cell A2)
736125605D17245324 (cell A3)
.... etc..

but after the scanner reads the number and writes in a cell I have to
hit ENTER and then scan the next barcode.
What I want find out is how can excel do this automaticaly after the
last number was written

thanks the help

Art.

 

[Bob]

Hi all,

I have a bar code scanner but when I read a bar code and it writes the
number to a cell I want it to go to the next cell (like hit enter). it
reads a 16 number barcode.

thanks

Hi,

Many (most?) scanners can be programmed to automatically insert a
control code at the end of the scan data. This should achieve the
result you want.

If you have a manual for your scanner it should have a configuration
section; usually you set up the scanner by reading configuration
barcodes printed in the manual. If you don't have a manual you might
be able to download a copy on line.

Bob

Bob Lounsbury
The Barcode Software Center
www.makebarcode.com

 

[Thomas Lutz]

It sounds like the bar code scanner that you have uses a "keyboard
Wedge" interface. This means that the bar code scanner works like a
second keyboard attached to your PC.
The scanner should have come with a users manual containing a number
of special programming bar codes that you can scan to enable and
disable different functionality. What you want is to program the bar
code scanner so that it adds either an Enter keystroke or a TAB
keystroke after each bar code that you scan. In Excel Enter moves the
cursor down to the next row and TAB moves to the right one cell.
In the bar code scanner users manual, this feature would be called
something like a "Suffix" or "Postamble" keystroke. If you cannot
figure out what bar codes to scan in the users manual, call the
manufacturer and have their tech support department tell you how to
configure the scanner.