Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar code Scaner
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar code Scaner
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 wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar code Scaner
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. On Sep 27, 10:07 am, JW wrote: 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 wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar code Scaner
On Sep 27, 8:41 am, DDavid wrote:
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar code Scaner
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. On Thu, 27 Sep 2007 13:41:54 -0000, DDavid wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to find code | Excel Discussion (Misc queries) | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
Write a code by code | Excel Discussion (Misc queries) |