How I can change length text to generate QR Code

[giggstae]

I load sample Excel but my data cannot generate full text

sample:

Text : ODH080014$OL1$PRM20H0013$Q34$LSTOREPC2$SRM1711200001
(in 1 line)

QR generate data only : ODH080014$OL1$PRM20H0013$Q34$LSTOREPC2$SRM

Please help suggest where the code I can change.

[JonasHeidelberg]

I think your problem might be related to the “stuttering“ I observed and fixed in my fork https://github.com/jonasheidelberg/barcode-vba-macro-only Generally these problems are likely to have to do with switching the encoding within the QR code (in your case the switch from captial letters to numbers-only does not happen). Could you check if my fork also shows your problem? Best Jonas

…

Am 22.11.2017 um 11:36 schrieb giggstae ***@***.***>: I load sample Excel but my data cannot generate full text sample: Text : ODH080014$OL1$PRM20H0013$Q34$LSTOREPC2$SRM1711200001 (in 1 line) QR generate data only : ODH080014$OL1$PRM20H0013$Q34$LSTOREPC2$SRM Please help suggest where the code I can change. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

[giggstae]

I download sample excel file follow this picture.

If I incorrect, please share a correct link.

and this is my file

[JonasHeidelberg]

You are right, the error you had was different from the one I fixed in February. Sorry for that! The code generating the eb() array is just deeply broken, I'd love to be able to talk to the original author to at least understand it better, this would greatly simplify debugging.

I will upload a quickfix for your problem in a few minutes. I hope this covers all use cases that you have, but I cannot be sure the code is now bug-free, because I don't have the time to set up a serious testing suite and/or rewrite the buggy code completely.

[giggstae]

It's work.

Thank you very much.