Enable Scanners for 18 Digit Barcode number Excel

- - Latest reply: BMiller58
Posts
10
Registration date
Friday August 10, 2018
Last seen
October 7, 2018
- Aug 24, 2018 at 10:03 PM
Good evening CCM folks,

I am currently wrapping up a project utilizing excel as a WIP History management system. I have all of the necessary components for barcode entry (which I developed in Excel), including a macro-enabled spreadsheet (Thanks to you guys!) to keep an account of all scanned entries.

I purchased a cheap Wonenice Barcode Scanner in order to test capabilities, but it would not scan an 18-digit barcode; which is crucial for this project to get off of the ground.

What kind of Scan gun do I need in order to scan an 18-digit barcode?
How do I format entries to the exact criteria that I need?

Thank you for any information that you are able to provide!
See more 

Your reply

2 replies

Posts
10913
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 10, 2018
0
Thank you
Man, unless you want to buy one of these, it is tough to find support. I did find the universal code name for an 18 digit code - ean-18.

I see that that scanner has capabilites of: Code11, Code39, Code93, Code32, Code128, Coda Bar, UPC-A, UPC-E,EAN-8, EAN-13, JAN.EAN/UPC Add-on2/5 MSI/Plessey, Telepen and China Postal CodeInterleaved 2 of 5, Industrial 2 of 5, Matrix 2 of 5.

Of course the ean-18 is not one of them. All things are possible if you know the requirements, and now you know that you have a requirement of ean-18 reading!

Awesome! Thank you for the insight!
Always a big help!
BMiller58
Posts
10
Registration date
Friday August 10, 2018
Last seen
October 7, 2018
-
Here is the barcode:


Need assistance of which scanner to look into
Respond to ac3mark
Posts
10913
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 10, 2018
BMiller58
Posts
10
Registration date
Friday August 10, 2018
Last seen
October 7, 2018
-
It appears to point me in the direction of 'gs1-128' barcode scanners. Is that a reasonable assessment?
Respond to ac3mark