Forum Discussion
safwen
Nov 08, 2022Brass Contributor
QR Code Microsoft Excel 365
Hey guys please is there any easy way to create QR code of text for example (part-0001) using excel
ratishkp You can assign this to a shape or button:
Sub foo()
ActiveWorkbook.RefreshAll
End Sub
Or if the PivotTable is on another sheet, you can add ActiveWorbook.RefreshAll to the Worksheet_Activate event, and it will automatically update whenever the sheet is selected.
2 Replies
Sort By
- mtarlerSilver Contributor
safwen short answer no I don't know of any "easy" way to create a QR code from text in Excel. In the attached example I create a UDI based on the HIBC issuing agency format and then a button will run a macro that will use an online API to generate a DataMatrix image.
So this isn't technically a QRcode but if there is an online QRcode generator API site it could be use as an easy template.
- safwenBrass ContributorThanks sir for the answer also i find QR code generator on internet and i run it for all cells using macros and it works. But i will see your solution, I'm up to learn new things 🙂