Qr code generator for solidworks drawing

[Ömür Tokman]

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.

[gupta9665]

Thank you for sharing

[Ömür Tokman]

Thank you for sharing

Actually i thank you. This is such a small thing compared to what you have done for us. Mr. Gupta I learned a lot from you.

[AlexLachance]

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.

2023-10-02_14-04-41.jpg

Awesome work Omur! I might give it a try and see if we could replace our bar codes with these.

[Ömür Tokman]

Awesome work Omur! I might give it a try and see if we could replace our bar codes with these.

I'm looking forward to your return, my mate.

[Frank_Oostendorp]

Would like to test it, but seems missing the QRGen file.

[Ömür Tokman]

Would like to test it, but seems missing the QRGen file.
image.png
image.png

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 (4.75 KiB) Viewed 5346 times

https://github.com/wqweto/VbQRCodegen

[Frank_Oostendorp]

(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.

[Ömür Tokman]

(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

Sorry, I didn't quite understand, is it working smoothly now?

[Frank_Oostendorp]

Sorry, I didn't quite understand, is it working smoothly now?

Yes, runs smoothly now.

[Ömür Tokman]

Yes, runs smoothly now.
image.png

Thank you very much for the feedback. It's nice to be useful to someone, the qr code link is nice.

[Frank_Oostendorp]

Thank you very much for the feedback. It's nice to be useful to someone, the qr code link is nice.

Thank you for creating this tool.
Might flood the SWYM'p with this code.

[mme]

A very well done job. Thanks

[AlexLachance]

I get this error when I run it:

[Frank_Oostendorp]

I get this error when I run it:
image.png

image.png

Had the same error. You have to de-select the missing reference, see my post above.

image.png (65.83 KiB) Viewed 5157 times

[AlexLachance]

Had the same error. You have to de-select the missing reference, see my post above.
image.png

Thanks Frank, didn't think it was the same error.

After clearing it, it works like a charm. Here's the macro with the missing reference removed for those who don't know how to remove it.

[Ömür Tokman]

Yes, I added that reference without removing it. Good thing you removed the reference and added it, I forgot to add it again.
Thanks Alex

[Monstrum Mathias]

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?

[DanPihlaja]

Thanks Frank, didn't think it was the same error.

After clearing it, it works like a charm. Here's the macro with the missing reference removed for those who don't know how to remove it.

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"

I am using SW 2022 SP4 on Windows 10

[SPerman]

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.

This link has a more thorough explanation.
https://kb.blackbaud.com/knowledgebase/Article/75344

[AlexLachance]

I get the following error whenever I run the modified version shared by Alex:
image.png

This happens after I type something in the box and select "generate QR Code"

I am using SW 2022 SP4 on Windows 10

Hey Dan,

Here's how to solve the issue:

Edit the macro and go in Tools>References

Uncheck the missing references and check the ones refering to 2022

[DanPihlaja]

Hey Dan,

Here's how to solve the issue:

Edit the macro and go in Tools>References

image.png

Uncheck the missing references and check the ones refering to 2022
image.png

Thank you. I couldn't figure out how people got to the references window.

I looked at the help file and the only thing it said was "show the references window" I was like, "HOW!!?"

lol

[hugozanga2024]

Thank you for sharing your QR code generator macro! It's impressive that you've crafted a solution tailored to your needs, especially without a programming background. I'll definitely give it a try. Hopefully, others in the community can help enhance it further. Great job!

[DeDum]

Thanks for sharing the qr generator!

My sketch picture dialog stays open. API says something about "This method does not support drawing documents" for the below code line
Part.SketchManager.InsertSketch2 True

Using this line of code instead seems to exit the sketch picture dialog.
Part.EditSheet 'exit edit sheet format

If you want to insert a couple QR codes without macro closing run it as vbModeless and comment out the unload
UserForm1.Show vbModeless
'Unload Me