Mynda, I just saw a RUclips short on this very subject and it was on my list for today to investigate it. I arrived at work and your email was there waiting for me on the very same subject. As usual, you explained the subject matter much better and in much more depth. You answered FAQ questions and presented options that allow me to not only obtain the functionality of generating QR codes but increase my skillset in Excel at the same time. Thanks for yet another very informative video on a fun subject. --Ian
That a bit like asking a Sunday league player to give ideas to a Premier League player 🙂 One thing that I need to get deeper into is Lambda, but Excel can do so many things, and in different ways. personally, I really enjoy when you introduce new functions that can otherwise be easily overlooked, but perhaps to accommodate new users it is a good idea with examples of more basic functions.
Looks so easy in your case, but what if it has to work on the shopfloor machine with Office 2013 and no access to the internet? I've been there. Tried to generate the image via the VBA, but I couldn't make it work. So I found some PHP library and created my own api on the internal server. As it was already XLSM file, I am just downloading the picture and placing it to the range in VBA. 😎
Great Video as usual! I prefer to do it with Lambda, but since the maximum size is 375, is it possible to make the size as an optional parameter with a default size of 150? So in case the user didn't enter any value it will be by default 150 and if entered more than 375, such as 400, the function takes 375.
@@MyOnlineTrainingHub Glad to hear this, but still looking forward for a video on these tricks!! This will open a wide door for many improvements to my existing lambda functions.
You can also generate QR for your home/company wifi, so that you can share wifi with guests without revealing the password each time and only those who drops by can access it.
Mynda, you've been a great help thank you for doing this. A bit off topic, I was watching your videos yesterday then suddenly it becomes unavailable saying channel is private. When going to your home page I was redirected to Vitalik Buterin's channel. Checking in this morning and now your channel says Ethereum?
Hi Mynda I had the same question. I currently use QRCode Generator which requires a hefty annual fee, but it does allow me to put our LOGO in the centre of the QR Codes. I think thats what Umaiz was talking about. Do you think that’s possible?
I've found that if I have a LAMBDA function in an open worksheet, copying a cell with that LAMBDA formula in it, and then pasting that CELL/FORMULA in another (new) Workbook will copy the LAMBDA function to the new Workbook. No need to copy the Worksheet.
How can i create multiple column data into 1 qr code ? Example i would like to keep colum a and b data together in one qr code? It would be great if u help
@MyOnlineTrainingHub thank you for reply. I would like to ask one more question if I combine A&B in one column...if I give code it's creating qr code for each row but I would like only 1 QR code for all row data is there any possibility mam? It could be helpful if I get help
QR codes are alternate ways to access a URL, so I'm a bit confused about what you're trying to generate a QR code for. Don't reply here as I won't see it. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
Probably, but I’m not sure if there are licensing restrictions about using these tools and charging for them. You’d have to look at their terms and conditions.
I have tried this with a spreadsheet and it works great, but it will only allow me to convert 10 cells to a QR code. Anything after that says the rate limit is reached.
Hello, I have been trying the Google URL, but I get the error : #VALUE! Also, there is a message on the Google website that says: "Warning: This API is deprecated. Please use the actively maintained Google Charts API instead." What can help this error? Thanks - AH
Sounds like you don't have a version of Excel that has the IMAGE function. I address the API deprecation in the video. It has been deprecated for many years, but it still works, so I don't expect it will stop working anytime soon.
This bottom of this page explains possible causes of the #BLOCKED! error: support.microsoft.com/en-us/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5
@@MyOnlineTrainingHub Thank you! I managed to sort that message. Sorry another question, is there a way to take the information from more than 1 cell to generate the QR code? Say I wanted the QR code to bring up a name and an email? Sorry I'm not very good with excel.
❓Which one of these 3 ways do you find the easiest to work with?
Simplify your work in Excel with my Advanced Formulas: bit.ly/advformulas0130
Mynda,
I just saw a RUclips short on this very subject and it was on my list for today to investigate it.
I arrived at work and your email was there waiting for me on the very same subject.
As usual, you explained the subject matter much better and in much more depth. You answered FAQ questions and presented options that allow me to not only obtain the functionality of generating QR codes but increase my skillset in Excel at the same time.
Thanks for yet another very informative video on a fun subject.
--Ian
That’s awesome to hear, Ian 😊 glad it was helpful 🙏
Dear Mynda
It's great that you keep finding new and very useful topics to bring up, thank you so much
Thank you for your kind words! Do you have any ideas/requests to share for the upcoming videos? 😃
That a bit like asking a Sunday league player to give ideas to a Premier League player 🙂
One thing that I need to get deeper into is Lambda, but Excel can do so many things, and in different ways.
personally, I really enjoy when you introduce new functions that can otherwise be easily overlooked, but perhaps to accommodate new users it is a good idea with examples of more basic functions.
@MyOnlineTrainingHub is it possible to make tutorial to generate qr code with nice label designer 10 software mam?
Fantastic, out of the box thinking at its best!
Thank you 😊
Looks so easy in your case, but what if it has to work on the shopfloor machine with Office 2013 and no access to the internet?
I've been there. Tried to generate the image via the VBA, but I couldn't make it work.
So I found some PHP library and created my own api on the internal server. As it was already XLSM file, I am just downloading the picture and placing it to the range in VBA. 😎
Yes, not as easy without a connection to the internet. Glad you found a workaround.
Cool!!! Till that, I have used the third way with different add-on, but now my favorite will be the first way. Thanks!
Thank you for the comment 😊
Great Video as usual!
I prefer to do it with Lambda, but since the maximum size is 375, is it possible to make the size as an optional parameter with a default size of 150?
So in case the user didn't enter any value it will be by default 150 and if entered more than 375, such as 400, the function takes 375.
Thanks 😊 yes, you could modify the lambda to allow for a default size value if the user omits it.
@@MyOnlineTrainingHub
Glad to hear this, but still looking forward for a video on these tricks!!
This will open a wide door for many improvements to my existing lambda functions.
🤯 Creating QR codes in Excel! Thank you for posting this video.
Pleasure 😊
You can also generate QR for your home/company wifi, so that you can share wifi with guests without revealing the password each time and only those who drops by can access it.
Fantastic idea! 😃👏
Mynda, you've been a great help thank you for doing this. A bit off topic, I was watching your videos yesterday then suddenly it becomes unavailable saying channel is private. When going to your home page I was redirected to Vitalik Buterin's channel. Checking in this morning and now your channel says Ethereum?
Thanks for your support. Our channel was hacked yesterday, and I've finally restored it, including the channel name.
Super awesome, thanks Mynda!
Thank you for the support! It means a lot!
great to see you back after the hack
Thank you for the support! 🙏
Should I have a specific formatting in the QR code cell?
No, no formatting required.
Do I need to creat the lamda function in every workbook or is there a way to access it across different workbooks?
You can either save the LAMBDA in your default workbook, or simply copy the formula from the example file into the file you want to use it in.
Wow! This was just awesome. Thanks for the video 😊
Thank you for your kind feedback, I really appreciate it 😊
Hi Mynda, great work! how do I retrieve a qr code from a qrcode string in excel?
Not sure what you mean by a 'qrcode string in Excel'?
Excellent,👍
How we can create the same with shape inside the QR code?
Not sure what you mean by 'with shape'.
@@MyOnlineTrainingHub Custom design QR code
Hi Mynda I had the same question. I currently use QRCode Generator which requires a hefty annual fee, but it does allow me to put our LOGO in the centre of the QR Codes. I think thats what Umaiz was talking about. Do you think that’s possible?
Amazing! Much thanks 🥳
Thank you for the comment and for watching!
Could the QR background be transparent in Excel ?
Do you mean if it is possible to save a QR code as a PNG file with a transparent background?
@@MyOnlineTrainingHub yes
I've found that if I have a LAMBDA function in an open worksheet, copying a cell with that LAMBDA formula in it, and then pasting that CELL/FORMULA in another (new) Workbook will copy the LAMBDA function to the new Workbook. No need to copy the Worksheet.
Thanks for sharing 👍
How can i create multiple column data into 1 qr code ? Example i would like to keep colum a and b data together in one qr code? It would be great if u help
You could concatenate the text first e.g. =A1&B1
@MyOnlineTrainingHub thank you for reply. I would like to ask one more question if I combine A&B in one column...if I give code it's creating qr code for each row but I would like only 1 QR code for all row data is there any possibility mam? It could be helpful if I get help
QR codes are alternate ways to access a URL, so I'm a bit confused about what you're trying to generate a QR code for. Don't reply here as I won't see it. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
Hi there. Can you create a QR code that will open a Document> Pdf, word etc.
Yes, if that document is stored in a web enabled URL e.g. saved on OneDrive or a web server.
Excelente vídeo, muchas gracias
Gracias!
This is excellent but sadly add-ins are locked at our company.
You can create a QR code in Excel without add-ins.
What about logo inside the QR code? Do you know a way to create QR codes eith logo inside in bulk ?
Good question, I don't know of any free ways to do this. Bit.ly allow you to with their paid service.
Great!
Glad it's helpful!
Can I create QR code like this and provide service to clients who want qr code for their website?
Probably, but I’m not sure if there are licensing restrictions about using these tools and charging for them. You’d have to look at their terms and conditions.
@@MyOnlineTrainingHub Thank you so much.
I have tried this with a spreadsheet and it works great, but it will only allow me to convert 10 cells to a QR code. Anything after that says the rate limit is reached.
Unfortunately, I think they changed the API recently.
Hello, I have been trying the Google URL, but I get the error : #VALUE! Also, there is a message on the Google website that says: "Warning: This API is deprecated. Please use the actively maintained Google Charts API instead." What can help this error?
Thanks - AH
Sounds like you don't have a version of Excel that has the IMAGE function. I address the API deprecation in the video. It has been deprecated for many years, but it still works, so I don't expect it will stop working anytime soon.
Just tried this first method but it says blocked! any advice would be great!
This bottom of this page explains possible causes of the #BLOCKED! error: support.microsoft.com/en-us/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5
@@MyOnlineTrainingHub Thank you! I managed to sort that message. Sorry another question, is there a way to take the information from more than 1 cell to generate the QR code? Say I wanted the QR code to bring up a name and an email? Sorry I'm not very good with excel.
the first method is not working for me. the qr codes generates but when i come to use my camera to scan it, the link is not popping up
Did you try making the QR code bigger? Have you tested the link you've fed into the formula actually works?
Perfect
Thank you!
hi, i'm doing it exactly like you did, but i'm getting the #Name? error
please advice, thank you
I suspect you don't have the IMAGE function in your version of Excel.
@@MyOnlineTrainingHub if my version of excel is missing the image function! Is it possible to add it?
Only by upgrading Excel. You cannot purchase new functions and put them in old versions of Excel.
can i use this in google sheet?
I expect so, yes.
can this function on excel 2016？
The add-in might be able to, but the IMAGE function is only available to Microsoft 365 users.
The image function don't work for me, any tips ?
Use the add-in instead.
How do I make a QR code for text
Use the Add-in and choose 'Custom' from the drop down.
Excel add error failed to load
Sorry to hear that. Hopefully you can still use the API method.
👏👏👏👏
Glad it was helpful 😁🙏
Also, Is it free?
100% free