After scanning a bar code I need it to enter and go to next row in excel

Here is what I did to fix the problem of the bar-code scanner not going to next line after a successful scan. (Symbol ls4000i,This fix should work for other models as well)

1. Get the manual for your scanner or here is a link to the Symbol LS400i
https://docs.symbol.com/manuals/3789802a.pdf
You will want to print off few pages that have the proper bar-codes for programming.

2. I usually start with setting scanner to the Default Parameter, this should be in section 5-7,page 50 of the manual.PRINT IT
Warning! If you set scanner to default, you need to be aware of which bar-code types you use. (We use UPC-A) Also if you have it programed for other things already you may not want to set all settings to default. You can skip to step 4. If you do not wish to reset all values to default.

Now scan the Default bar-code.


3. Now program scanner to Enable your bar-code type. (For us Enable UPC-A bar-code is in section 5-22,page 66. PRINT IT

Now Scan the Enable (your bar-code type UPC-A, UPC-E,etc etc)

4.Next You need to set a Suffix Value. The scan Suffix bar-code is found in section 5-80, page 124. PRINT IT

Now Scan the Scan Suffix bar-code

This prepares the scanner for the code of the whatever Suffix you want to add.

5. The Suffix you want to add to fix this particular problem is ENTER. So that it goes to the next line. There is a prefix/suffix value chart on page 162 table A-4. The code for ENTER Is 7013. In order to enter this code you will need to print off the Numeric Bar Codes found in section 5-109,5-110,pages 153,154. PRINT IT

Now scan in 7013 one number at a time to program ENTER as the suffix.

6.Now you have to program the Scan Data Transmission Format found in section 5-81,5-82, pages 125,126 . PRINT IT
(This lets the scanner know to transmit the Suffix after the data.)

First scan the Scan Options Bar-code.
Second scan the <DATA><SUFFIX> bar-code.
Last scan the ENTER Bar-Code.

YOUR DONE !

Your scanner should be working now. Also look through the manual there are some nice functions that can be turned on and off with a simple bar code scan. Such as volume and tone of beep etc etc.

Hope this helps

Nate N7w7

Hi,

This can be possible, therefore it is not an Excel setting. You would need
to use the software that comes with your bar-code reader to configure this.

Try looking in your bar-code reader documentation for "Append Enter" or
"Append Carriage Return"