How to Create QR Codes in Excel - Tutorial, no Add-Ins
Learn how to generate QR codes from a list in your Excel spreadsheet. APi used: goqr.me/api/ GIST: gist.github.com/chicagocomput... #qr #excel #code
Жүктеу.....
Пікірлер: 44
@ExcelGoogleSheets2 жыл бұрын
Excel Create PDF Files From Data kzread.info/dash/bejne/l5uju7hxg82tmpc.html Excel Dynamic Timestamps kzread.info/dash/bejne/fXh5mM6QetiamcY.html Excel Checkboxes kzread.info/dash/bejne/f2uuwa6SlsWcf9Y.html
@theforce3810 Жыл бұрын
Just Great ! Extreme clarity on the process with simple explanation supported with clear voice.
Thank you so much! You have saved me hours of work 😢 thank you!
@dominic677969 Жыл бұрын
Very helpful, thank you
@edgarmascorroescobar7140 Жыл бұрын
Great video!! Short code and effective
@ExcelGoogleSheets
Жыл бұрын
🙂
@TheNtjrg332 жыл бұрын
This is great. This was short and to the point. I have to ask though, if the spreadsheet has merged cells then the does not work, how would we need to modify the VBA to ensure everything works with Merged cells. For example your QR code would take up two cells, the URL one cell and I would have a blank cell in between QR codes. Would love to see how to program for that scenario. But I did love the video and it works beautifully.
@gigi5gls10 ай бұрын
Hi! Thank you for this tutorial! How can we get this to print to Avery labels with a name next to it? Thanks!
@clipsupportgroup82922 жыл бұрын
very nice
@lacorelabs67242 жыл бұрын
can you also please show how to print this QR code on Labels by using printer such as Zebra? you are awesome btw.
@SmallSpoonBrigade Жыл бұрын
This is a good video. But, the scale is going to be 1 and 1 for the horizontal and vertical widths if you've already set the size of the cell to match the 150x150 size that you're generating. Any time the cell size already matches the image size, there' no point in scaling it. I'm not even sure that those lines really even need to be there, but it's nice if you eventually decide to change it. (For example to have a larger and a smaller on in the same sheet)
@phiguratech9631 Жыл бұрын
You are great!
@ExcelGoogleSheets
Жыл бұрын
👍
@samytagba4004 Жыл бұрын
Great Video. Is it possible to do all-in-one QR code for all Social media for instances?
@chrisgoes96103 ай бұрын
Very useful and helpful. I am not a programmer and managed to follow these steps easily. Many thanks for sharing. I have a question though - if my url address is every 6th row in excel, for example, how would i change the code?
@tecstalinramirez2 жыл бұрын
This is awesome, I need to do this in Google sheets.
@ExcelGoogleSheets
2 жыл бұрын
Google Sheets version kzread.info/dash/bejne/eaptmLalZ7WpqNI.html
@tecstalinramirez
2 жыл бұрын
@@ExcelGoogleSheets OMG, I'm so grateful, thank you, I'll use this on my job, thank you, thank yo, thank you, greetings from Dominican Republic
@rogerdailey9357 Жыл бұрын
I checked again today and the website is working now
@muhammedosman10022 жыл бұрын
this is great
@muhammedosman1002
2 жыл бұрын
Q--, hi I was trying to find search function which will look for the matches of alphabets of specific range and make a new columns with the returns. i was trying to find it for while but no luck
@ExcelGoogleSheets
2 жыл бұрын
I don't understand what exactly you're trying to do.
@trevorheatherfoster6122 Жыл бұрын
Loved this, exactly what I'm after Is there a way to just have this show "Data Information" IE : Production information of a Job Number Say; Date ###### Operator ##### Shift ## "EncodeURL" is for Web Address, can other functions be used ? Regards, Trevor
@ExcelGoogleSheets
Жыл бұрын
You can use any data that's valid for generating a QR code.
@BartFain Жыл бұрын
Does this process make a dynamic QR code? If I were to change the destination URL in the future, would the QR code image stay the same? Wanting to avoid having to re-print QR codes. Thank you.
@ExcelGoogleSheets
Жыл бұрын
Yes, it will remain the same. You would need to regenerate the QR code.
@BartFain
Жыл бұрын
@@ExcelGoogleSheets Thank you for the quick reply. So if I want the QR code to remain the same but to take me to a different URL - just don't regenerate it?
@ExcelGoogleSheets
Жыл бұрын
You'll have to generate a new QR code in order for it to take you to a new URL.
@mahmoudkamal14 ай бұрын
How can i change from URL to VCF ?? can you help me !
@rogerdailey9357 Жыл бұрын
My apologies it’s working just fine now. Great presentation
@ExcelGoogleSheets
Жыл бұрын
Not sure. It might have been a temporary down time with their API.
@rogerdailey9357
Жыл бұрын
@@ExcelGoogleSheets yes it was then next day it worked fine then down again on the 3rd day. I switched to the Google api and it has never been down. I used your presentation but substituted Google.
@ExcelGoogleSheets
Жыл бұрын
👍
@ExcelGoogleSheets
Жыл бұрын
Common problem with all third-party services. You just need to find the right one at that time.
@cevalier11 ай бұрын
what if we want to make the QR code as downloadble pdf and it is locked? SHould we use Github too for repository?
@BestFriendsForeverTrue Жыл бұрын
Please show me how can I save all qr code from PNG file in worksheet to computer?
@user-dt1ix5sq3v Жыл бұрын
Is there a way to make datamatrix code just like this?
@mindyhill30057 ай бұрын
I am trying to link the information to send me an email instead of connect to a link. How do I link the code to my outlook email?
@todinirinaelie82259 ай бұрын
can you help please, my data is in more row who contains four column. what become the codes?
@renanwk01 Жыл бұрын
I cant do the same, show the error 1004 - it is not possible to get the Insert property of the picture class... Only do 1 qr code, but 2 or plus i cant do the looping... Do you can help me? Thanks
@MrDexyw8r
Жыл бұрын
Did you find the solution for this error? I have same problem
@love2boutdoors4749 ай бұрын
How can you make a QR code for just a number for scanning on an inventory system scanner? The QR code appears but doesn’t generate that search for number command.
@rogerdailey9357 Жыл бұрын
I tried the example only got a white screen. Perhaps website it down
Пікірлер: 44
Excel Create PDF Files From Data kzread.info/dash/bejne/l5uju7hxg82tmpc.html Excel Dynamic Timestamps kzread.info/dash/bejne/fXh5mM6QetiamcY.html Excel Checkboxes kzread.info/dash/bejne/f2uuwa6SlsWcf9Y.html
Just Great ! Extreme clarity on the process with simple explanation supported with clear voice.
ขอบคุณมากค่ะ มีประโยชขน์มากเลยค่ะ ตามหาvideo ที่ทำง่ายๆแบบนี้เลยค่ะ
Thank you so much! You have saved me hours of work 😢 thank you!
Very helpful, thank you
Great video!! Short code and effective
@ExcelGoogleSheets
Жыл бұрын
🙂
This is great. This was short and to the point. I have to ask though, if the spreadsheet has merged cells then the does not work, how would we need to modify the VBA to ensure everything works with Merged cells. For example your QR code would take up two cells, the URL one cell and I would have a blank cell in between QR codes. Would love to see how to program for that scenario. But I did love the video and it works beautifully.
Hi! Thank you for this tutorial! How can we get this to print to Avery labels with a name next to it? Thanks!
very nice
can you also please show how to print this QR code on Labels by using printer such as Zebra? you are awesome btw.
This is a good video. But, the scale is going to be 1 and 1 for the horizontal and vertical widths if you've already set the size of the cell to match the 150x150 size that you're generating. Any time the cell size already matches the image size, there' no point in scaling it. I'm not even sure that those lines really even need to be there, but it's nice if you eventually decide to change it. (For example to have a larger and a smaller on in the same sheet)
You are great!
@ExcelGoogleSheets
Жыл бұрын
👍
Great Video. Is it possible to do all-in-one QR code for all Social media for instances?
Very useful and helpful. I am not a programmer and managed to follow these steps easily. Many thanks for sharing. I have a question though - if my url address is every 6th row in excel, for example, how would i change the code?
This is awesome, I need to do this in Google sheets.
@ExcelGoogleSheets
2 жыл бұрын
Google Sheets version kzread.info/dash/bejne/eaptmLalZ7WpqNI.html
@tecstalinramirez
2 жыл бұрын
@@ExcelGoogleSheets OMG, I'm so grateful, thank you, I'll use this on my job, thank you, thank yo, thank you, greetings from Dominican Republic
I checked again today and the website is working now
this is great
@muhammedosman1002
2 жыл бұрын
Q--, hi I was trying to find search function which will look for the matches of alphabets of specific range and make a new columns with the returns. i was trying to find it for while but no luck
@ExcelGoogleSheets
2 жыл бұрын
I don't understand what exactly you're trying to do.
Loved this, exactly what I'm after Is there a way to just have this show "Data Information" IE : Production information of a Job Number Say; Date ###### Operator ##### Shift ## "EncodeURL" is for Web Address, can other functions be used ? Regards, Trevor
@ExcelGoogleSheets
Жыл бұрын
You can use any data that's valid for generating a QR code.
Does this process make a dynamic QR code? If I were to change the destination URL in the future, would the QR code image stay the same? Wanting to avoid having to re-print QR codes. Thank you.
@ExcelGoogleSheets
Жыл бұрын
Yes, it will remain the same. You would need to regenerate the QR code.
@BartFain
Жыл бұрын
@@ExcelGoogleSheets Thank you for the quick reply. So if I want the QR code to remain the same but to take me to a different URL - just don't regenerate it?
@ExcelGoogleSheets
Жыл бұрын
You'll have to generate a new QR code in order for it to take you to a new URL.
How can i change from URL to VCF ?? can you help me !
My apologies it’s working just fine now. Great presentation
@ExcelGoogleSheets
Жыл бұрын
Not sure. It might have been a temporary down time with their API.
@rogerdailey9357
Жыл бұрын
@@ExcelGoogleSheets yes it was then next day it worked fine then down again on the 3rd day. I switched to the Google api and it has never been down. I used your presentation but substituted Google.
@ExcelGoogleSheets
Жыл бұрын
👍
@ExcelGoogleSheets
Жыл бұрын
Common problem with all third-party services. You just need to find the right one at that time.
what if we want to make the QR code as downloadble pdf and it is locked? SHould we use Github too for repository?
Please show me how can I save all qr code from PNG file in worksheet to computer?
Is there a way to make datamatrix code just like this?
I am trying to link the information to send me an email instead of connect to a link. How do I link the code to my outlook email?
can you help please, my data is in more row who contains four column. what become the codes?
I cant do the same, show the error 1004 - it is not possible to get the Insert property of the picture class... Only do 1 qr code, but 2 or plus i cant do the looping... Do you can help me? Thanks
@MrDexyw8r
Жыл бұрын
Did you find the solution for this error? I have same problem
How can you make a QR code for just a number for scanning on an inventory system scanner? The QR code appears but doesn’t generate that search for number command.
I tried the example only got a white screen. Perhaps website it down