QR code Generator

[arkusM]

Does anyone know of any VBA code that can generate a QR code? The algorithm is publicly available but was wondering if anyone has bothered to post open-sourced VBA code.

There are lots of free websites and apps to generate but what about native Excel generation? There are API's out there but some cost a fair bit, some not so much, but around my owrkplace.... well that's not going to happen.

Cheers
Mark

 

[arkusM]

--Bump--
Wow, page 15 over night...

 

[Gerald Higgins]

What's a QR code ?
Got a link to the algorithm ?

 

[arkusM]

Wiki: http://en.wikipedia.org/wiki/QR_code

The ISO/IEC pdf: http://raidenii.net/files/datasheets/misc/qr_code.pdf


EDIT: Just found this, but have not read it yet, not sure I have the technical ability to make the code either way... LOL
Apperently not difficult but was wondering if someone had done a VBA version.

 

[sdfwefs]

What's a QR code ?
Got a link to the algorithm ?

This two professional passages may be helpful to you. Take a look: ASP.NET QR Code barcode generator SDK and QR Code barcode intruduction.

 

[lilycan]

i can't not provide any algorithm on vba barcode generator, but i am happy to introduce you excel qr code barcode add-on. you can check the free trial package before you install.

 

[arkusM]

An alternate method I found. Uses a Google API and generates "realtime" in you worksheet.
Seems to work with any text. The example workbook as the input cell restricted toa list but if you remove the data Validation you can input text.

https://sites.google.com/site/e90e50fx/home/generate-qrcode-with-excel

 

[JohanSchoeman]

I have posted a project here:

https://www.dropbox.com/s/xjo8b3wdcdkdmld/QR CODE FINAL NEW ECC CALC DROP BOX.xlsm

 

[JohanSchoeman]

Have posted VBA project for PDF417 here:

<input readonly="True" type="text" id="pyxl2590067460806085465" value="https://www.dropbox.com/s/xow3mxplovkrjpc/PDF417%20ver6%20cleaned.xlsm?dl=0" class="text-input-input" style="font-family: 'Open Sans', 'lucida grande', 'Segoe UI', arial, verdana, 'lucida sans unicode', tahoma, sans-serif; font-size: 13px; color: rgb(61, 70, 77); border-color: rgb(229, 229, 229); padding: 3px 6px; width: 574px; margin: 0px; min-height: 30px; box-sizing: border-box; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px; -webkit-appearance: none; height: 34px;">

 

[Arnaud951]

I have used this API for a long time and it was working well...
Now I have to code this text: "410~CELLA%EB[11" and it doesn't work...
It seems that the chain "%EB[" is not possible to code????

Any thoughts about that??

Thanks,

Arnaud