Enable Scanners for 18 Digit Barcode number Excel [Closed]

- - Latest reply: BMiller58
Posts
10
Registration date
Friday August 10, 2018
Status
Member
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 

2 replies

Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1568
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
Status
Member
Last seen
October 7, 2018
-
Here is the barcode:


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