June7
AWF VIP
- Local time
- Today, 14:35
- Joined
- Mar 9, 2014
- Messages
- 5,595
This database developed from discussion in https://www.access-programmers.co.uk/forums/showthread.php?t=299589
Offer no guarantees but it does seem to work nicely.
At its core is an Excel workbook built by Johan Schoeman - his details are in the workbook. Be aware the workbook is password protected by the author and therefore no analysis of its VBA can be done. I am not able to get QRCode images to generate from the workbook alone. Thanks to @arnelgp for locating this workbook and building an Access application to manipulate it. Even though code worked for him, it would not for several of us testing. Posted here is my modified version of that Access file. Workbook is embedded in table Attachment field. Code extracts and manipulates workbook.
Also attached is a completely different workbook that generates QRCode patterns. This one does not use VBA. Found at http://blog.ambor.com/2013/03/create-qr-codes-in-excel-or-any.html
Offer no guarantees but it does seem to work nicely.
At its core is an Excel workbook built by Johan Schoeman - his details are in the workbook. Be aware the workbook is password protected by the author and therefore no analysis of its VBA can be done. I am not able to get QRCode images to generate from the workbook alone. Thanks to @arnelgp for locating this workbook and building an Access application to manipulate it. Even though code worked for him, it would not for several of us testing. Posted here is my modified version of that Access file. Workbook is embedded in table Attachment field. Code extracts and manipulates workbook.
Also attached is a completely different workbook that generates QRCode patterns. This one does not use VBA. Found at http://blog.ambor.com/2013/03/create-qr-codes-in-excel-or-any.html
Attachments
Last edited: