QR Code Generator


This function can be used when you want to convert every cell of a range in an Excel sheet to a QRCode.

As an example, suppose we want to convert a list of product names into QR codes.

qr code generator


To do it, we can use QRCode “Generator“.

Click the ribbon-button “AutoVBA->QRCode Generator“.

vba code module


Then, indicate “input range”, “QR code size”, “QR code ECC level”, “output start range” in the dialog “QRCode Generator”.

If you want to save the QR Code images as files, you should indicate “Output Path”.

vba code module


Then, click the button “Generate”.

QR codes for each cell are automatically generated.

vba code module


And, QR codes are saved as png files.

vba code module