Barcode 128 Issue

Copper Contributor

I am having a small issue.

I am using Excel as is from MS365 Apps for Enterprise (exact build version 2308, build 16731.20234)

We are trying to setup an eventual template we can use to automate our internal pick sheets, and get off a custom web based conflagration of mucky code. I have setup the template the way I need, and have tried both the VBA method mentioned at https://barcodelive.org/generate-code-128-barcode-font-for-excel, as well as using the ConnectCode Barcode Fonts Helper availably via office add-ins. I have gotten the code128.ttf font by Grand Zebu at dafont.com and installed it.

 

I have a column setup and formatted as text only, this is where the information to be turned into a barcode goes. (AE)

 

I have a second column which I used for the VBa test of things, which displays the actual encoded dat, with start, atop and check digits in it (AF)

 

Finally I have a column that if forced to the code128 font, 24pt. (B)

 

When I put in the data to be encoded, I do correctly get out the encoded data, using the formula '=Code128(AE cell address)'

 

When I set the B column formula to '=<AF cell address>' all I get is the code for literally that cell address, it is refusing to take the value there and encode it.

 

Similarly, when I use the ConnectCode, and set B to '=ConnectCode.Encode128Auto(AE cell address)' I get that exact string, it is not taking the value.

If I instead apply the above code to another cell, I get out the encoded value I would get out of the VBA (AF column)

As a test, I tried moving the data to be encoded to column A, but got the same errors. Does anyone have any ideas?

I am testing and comparing the generated Barcodes using a scanner, and barcodes printed out by other aspects of our shops computer systems.

 

 

 

 

 

2 Replies
Hi,
Did you have any luck fixing this?

This is what is happening with my Barcodes
I use a handheld scanner, a CS3070 to scan barcodes into my XL order form.
My Excel order form stopped uploading/inputting all the characters from my handheld scanner.
It won’t upload them in the cell that is designated for the UPC.
However, it will upload them into any other cell in the spreadsheet.
Also, the scanning works on my MacBook Pro but not on my iPad.
The company that I work for has scoured the order form and says all the formulas are correct.

What do I need to do to get it to read and input all the digits into the correct cell?
Thank you.
Brooke 
If you are facing issues installing a font, you can visit and download from https://dafont.style/ all working font styles. All fonts are compatible with Windows 10 and 11.