What's my best bet for generating QR codes? I am using it in production instead of the normal code 39 barcode and need to be able to generate the code in excel from data entered in a cell. Any ideas?
What's my best bet for generating QR codes? I am using it in production instead of the normal code 39 barcode and need to be able to generate the code in excel from data entered in a cell. Any ideas?
Do you want to have it as an object in the sheet or just a link to it?
Entia non sunt multiplicanda sine necessitate
I'd prefer it to be an object right in the sheet for ease of use, but I'll take what I can get! THANK YOU!
OK, Im getting there. In cell H1 I have a PN 665100AM and in cell L1 I have a formula: =CONCATENATE("https://chart.googleapis.com/chart?chs=125x125&cht=qr&chl=",H1,"")
The code below takes the concatenated URL and generates and inserts a QR. Now I need help positioning the picture (QR) in cell K1.
Please Login or Register to view this content.
Last edited by Cutter; 08-13-2012 at 12:13 PM. Reason: Added code tags
if K1 has been sized to hold the shape then to center it usePlease Login or Register to view this content.
Please Login or Register to view this content.
@ kwengerd
Welcome to the forum.
Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.
mybe this is a convinent and easy way:http://www.barcodelib.com/barcode_software/main.html
Try to see this QR Code barcode add-in for Excel:
http://www.onbarcode.com/excel_barcode/qrcode.html
You can also find many other barcode generators there, like Java QR Code barcode generator SDK, etc.
For a more generalized solution, the following is a function that when placed to the right of a cell with the string that is to be converted to a QR Code will place the QR code for that cell to the right of the cell with the function. So in the example above, if "PN 665100AM" is in cell H1, place the following formula in I1:
""Formula:Please Login or Register to view this content.
This formula can be copied to other cells. The relative reference to I1 will change as the formula is copied. The cell reference should always be equal to the cell that the formula occupies.
Then create the following function in VBA.
Every time the worksheet is recalculated, a new QR Code based on the then current contents of H1 will be positioned over cell J1.Please Login or Register to view this content.
To avoid, duplicate QR codes being placed over each other, one may want to write an additional subroutine to delete Pictures before recalculation. That has not been provided here.
Best Regards.
I need to create qr codes in excel and most in advance should link each qr code barcode to spreadsheet cell and dynamically update information. Any way?
Welcome to the forum.
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks