Hello everybody,
This is the macro I’ve been wanting to make for a while.
First of all, I would like to remind you! I am not a programmer, the macro I made is to meet my needs. And it works well enough to meet my needs for now.
It would be great if someone who understands the software could fill in the shortcomings of the macro.
It adds the text written in the textbox to the page as a QR code.
The reason I went with the macro is that it is a single file, does not require installation and I want to write only with VBA. The address where I downloaded the QR code generating module is written on the module page. Does not require internet.
As I said at the beginning, this macro is just to meet my basic needs. “Be sure to test it!” I’m sharing it in case anyone wants to improve it.
You don’t need to add any references.
That reference is from a different attempt.
I added a module to create a qr code, but if you need to add it too, I’m adding it here.
image.png VbQRCodegen-master.zip (17.6 KB) https://github.com/wqweto/VbQRCodegen
(Thanks, sorry but it throws another error. Let’s see if Alex can test it.)
After clearing the select box of the missing reference, runs great. Good job.
image.png
Many thanks Ömür. This is a really useful code.
I use it for displaying dropbox-links for pdf and edrawings on the SolidWorks drawings.
When it inserts the picture it varies a great deal in size. Is there an easy way to adjust this size to a fixed value within the code?
What would be truly awesome is if the code was able to get the dropbox path of the pdf with the same name as the drawing and then paste that into the window. Is that at all possible within a macro in SW or is that wanting too much?
I get the following error whenever I run the modified version shared by Alex:
This happens after I type something in the box and select “generate QR Code”
In the VBA editor, go to ‘Tools-> References’. There is probably a broken reference that either needs to be unchecked, or more likely pointed to the correct dll.
