Require VBA Code for QR Code

**chintamani.avinash** · 10-19-2020, 03:21 PM

Hello,
I want to generate QR code in my excel file with vba coding with the help of button. I have created one excel file with the help of vba code which i have found on internet. But problem is that, when i try to save my excel file after generating QR code with the help of vba coding, my EXCEL FILE STOP TO RESPOND. Please provide solution for smooth working of file. File is attached.

**Keebellah** · 10-20-2020, 03:29 AM

How do you expect other to help you if you do not include the tools reference dor the barcode geberator.
The reference you are using is on your desktop and is, if i read it correctly for Microsoft Access, maybe that's the problem:
Microsoft Access BarCode Control 14.0

**chintamani.avinash** · 10-20-2020, 01:32 PM

Thanks for your reply. Frankly speaking i am very new to VBA and learning things from internet sources so do not understand quickly which tool is in PC and creating problem. Microsoft tool 14.0 was installed in my pc but i think lateron i have removed it. For this file i have tried to used pure vba code and believe that this tool is not done any intervention. I think previous file is not working good so I also attached new file. Your help will be appreciated.

**Keebellah** · 10-20-2020, 01:53 PM

Good, this file works, I don't get an error or a hanging system
What's the problem?
I'm running the same Office version (2016)

**chintamani.avinash** · 10-20-2020, 01:57 PM

When i generate QR code and try to save file. My excel file stop to respond / work and closes itself.

**Keebellah** · 10-20-2020, 02:24 PM

It works fine here
Have you tried to take it step by step in the vba code?

**chintamani.avinash** · 10-20-2020, 02:34 PM

Means with the text "FIN STAT SALE NP 0 CA 0 LOAN INVEST DRS Cash in Hand Cash @ Bank Balance 0 Depreciation 0 Closing WDV 0 HP 80C 0 Ch VI 0 Tax Payble 0" it is working fine at your side?
please tell how to take step by step in the vba code. Because i have taken and using the code as it is with some minor modification.

**chintamani.avinash** · 10-20-2020, 02:40 PM

This is the screenshot of the problem.

**chintamani.avinash** · 10-20-2020, 02:50 PM

Also when i generate QR code, before saving, movement of the cursor within sheet becomes slow. And after this when i try to save it gives above error.

**Keebellah** · 10-20-2020, 05:11 PM

There is indeed something wrong after you try to save the file, indeed it stops working. Cannot figure out why.
Try this file, I've used it in the past.
You enter the string in Cell A2 and then Click Cell A11 as if you would edit it, and the code runs, and works
I compared the result with your generated QR and it's identical and takes me to the same link

**chintamani.avinash** · 10-21-2020, 12:54 AM

Thanks for your response. I tried this file and works well. But this file requires internet connection. Data is to be sent to some URL and QR is generated. Can you make this file work in offline mode also? Or any other solution? Thanks.

**Keebellah** · 10-21-2020, 02:31 AM

Honestly, no, I tried other code generators, they all work fine except with the text you're using, so there must be something there that forces Excel to close down but I don't know.

If you place another text in your file then it works.
So you will have to use the one that requires Internet or else you will have to do more testing. I don't have a better answer for you

**chintamani.avinash** · 10-21-2020, 07:21 AM

Okk, thank you for your efforts. In case if you find any solution please let me know. Thanks again.

**Keebellah** · 10-21-2020, 07:51 AM

I placed a question at on another forum that did some QR coding but my guess it's not the code but the text and the length of it.
It's not really something you place in a QR-Code

**Keebellah** · 10-21-2020, 08:44 AM

Sorry this is as far as I can go.
Your text causes the following error and hangs-up the system

If you pass a real url or some other text it works fine.

**chintamani.avinash** · 10-21-2020, 09:51 AM

Thanks a lot. Am i having long text? Can i alter VBA code for long text?

**Keebellah** · 10-21-2020, 10:59 AM

Good luck, I suggest you contact the person or persons responsible for the code snippet you used.
It's mentioned in the VBA comments.
I'm not going to do anything since it works for normal standard texts, but not with whole search values and all the things you used.
Like I said a QR-Code must have some limitations, so, well, google for that and see whatever you can find.

**chintamani.avinash** · 10-21-2020, 02:31 PM

yea sure, i will try to find out and if find something then will contribute here. Thanks for support.

Require VBA Code for QR Code

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Re: Require VBA Code for QR Code

Thread Information

Users Browsing this Thread

Similar Threads

Require VBA Code for Report

Require VBA Code for Summary Report

[SOLVED] Help require to amend the code

[SOLVED] Require a code to pop message modification

[SOLVED] Require vba code behind the sheet.

Logic identifie- Require help on code

Change code to require a Response

Bookmarks

Bookmarks

Posting Permissions