❓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
@ianwebster2296
8 ай бұрын
Mynda, I just saw a KZitem 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
@MyOnlineTrainingHub
8 ай бұрын
That’s awesome to hear, Ian 😊 glad it was helpful 🙏
@andre6543
Ай бұрын
🤯 Creating QR codes in Excel! Thank you for posting this video.
@MyOnlineTrainingHub
Ай бұрын
Pleasure 😊
@ivanbork4175
8 ай бұрын
Dear Mynda It's great that you keep finding new and very useful topics to bring up, thank you so much
@MyOnlineTrainingHub
8 ай бұрын
Thank you for your kind words! Do you have any ideas/requests to share for the upcoming videos? 😃
@ivanbork4175
8 ай бұрын
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.
@sowjanyas3846
5 ай бұрын
@MyOnlineTrainingHub is it possible to make tutorial to generate qr code with nice label designer 10 software mam?
@normundserglis1795
8 ай бұрын
Cool!!! Till that, I have used the third way with different add-on, but now my favorite will be the first way. Thanks!
@MyOnlineTrainingHub
8 ай бұрын
Thank you for the comment 😊
@FEBear1
7 ай бұрын
great to see you back after the hack
@MyOnlineTrainingHub
7 ай бұрын
Thank you for the support! 🙏
@chrism9037
8 ай бұрын
Super awesome, thanks Mynda!
@MyOnlineTrainingHub
8 ай бұрын
Thank you for the support! It means a lot!
@IamTheReaper911
8 ай бұрын
Wow! This was just awesome. Thanks for the video 😊
@MyOnlineTrainingHub
8 ай бұрын
Thank you for your kind feedback, I really appreciate it 😊
@cjkleynhans
Ай бұрын
Great!
@MyOnlineTrainingHub
Ай бұрын
Glad it's helpful!
@mikrom
8 ай бұрын
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. 😎
@MyOnlineTrainingHub
8 ай бұрын
Yes, not as easy without a connection to the internet. Glad you found a workaround.
@DavidVsOficial
4 ай бұрын
Excelente vídeo, muchas gracias
@MyOnlineTrainingHub
4 ай бұрын
Gracias!
@ireyel
7 ай бұрын
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?
@MyOnlineTrainingHub
7 ай бұрын
Thanks for your support. Our channel was hacked yesterday, and I've finally restored it, including the channel name.
@yassirkhalid5376
7 ай бұрын
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
7 ай бұрын
Thanks 😊 yes, you could modify the lambda to allow for a default size value if the user omits it.
@yassirkhalid5376
7 ай бұрын
@@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.
@erdal4687
8 ай бұрын
Perfect
@MyOnlineTrainingHub
8 ай бұрын
Thank you!
@razvanafloarei6256
7 ай бұрын
Should I have a specific formatting in the QR code cell?
@MyOnlineTrainingHub
7 ай бұрын
No, no formatting required.
@CG-em4kg
7 ай бұрын
Hi Mynda, great work! how do I retrieve a qr code from a qrcode string in excel?
@MyOnlineTrainingHub
7 ай бұрын
Not sure what you mean by a 'qrcode string in Excel'?
@jdalco
8 ай бұрын
Do I need to creat the lamda function in every workbook or is there a way to access it across different workbooks?
@MyOnlineTrainingHub
8 ай бұрын
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.
@TheUmaiz
8 ай бұрын
Excellent,👍 How we can create the same with shape inside the QR code?
@MyOnlineTrainingHub
8 ай бұрын
Not sure what you mean by 'with shape'.
@TheUmaiz
8 ай бұрын
@@MyOnlineTrainingHub Custom design QR code
@rosemarygrundy3539
7 ай бұрын
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?
@Noura.sa19
8 ай бұрын
Could the QR background be transparent in Excel ?
@MyOnlineTrainingHub
8 ай бұрын
Do you mean if it is possible to save a QR code as a PNG file with a transparent background?
@Noura.sa19
8 ай бұрын
@@MyOnlineTrainingHub yes
@MelodyCooper-p8n
7 ай бұрын
Just tried this first method but it says blocked! any advice would be great!
@MyOnlineTrainingHub
7 ай бұрын
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
@MelodyCooper-p8n
7 ай бұрын
@@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.
@vedmuchandikar-xu6jd
8 ай бұрын
Can I create QR code like this and provide service to clients who want qr code for their website?
@MyOnlineTrainingHub
7 ай бұрын
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.
@vedmuchandikar-xu6jd
7 ай бұрын
@@MyOnlineTrainingHub Thank you so much.
@alisami5434
4 ай бұрын
hi, i'm doing it exactly like you did, but i'm getting the #Name? error please advice, thank you
@MyOnlineTrainingHub
4 ай бұрын
I suspect you don't have the IMAGE function in your version of Excel.
@alisami5434
4 ай бұрын
@@MyOnlineTrainingHub if my version of excel is missing the image function! Is it possible to add it?
@MyOnlineTrainingHub
4 ай бұрын
Only by upgrading Excel. You cannot purchase new functions and put them in old versions of Excel.
@malakamir8491
7 ай бұрын
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
@MyOnlineTrainingHub
7 ай бұрын
Did you try making the QR code bigger? Have you tested the link you've fed into the formula actually works?
@ahawk850
4 ай бұрын
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
@MyOnlineTrainingHub
4 ай бұрын
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.
@yametekudasai676
5 ай бұрын
can i use this in google sheet?
@MyOnlineTrainingHub
5 ай бұрын
I expect so, yes.
@mikes4177
5 ай бұрын
How do I make a QR code for text
@MyOnlineTrainingHub
5 ай бұрын
Use the Add-in and choose 'Custom' from the drop down.
@geisamendes5887
7 ай бұрын
👏👏👏👏
@MyOnlineTrainingHub
7 ай бұрын
Glad it was helpful 😁🙏
@F5Yourself
8 ай бұрын
Excel add error failed to load
@MyOnlineTrainingHub
7 ай бұрын
Sorry to hear that. Hopefully you can still use the API method.
@Noura.sa19
8 ай бұрын
Also, Is it free?
@MyOnlineTrainingHub
8 ай бұрын
100% free
@VVeiQuek
8 ай бұрын
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.
@MyOnlineTrainingHub
8 ай бұрын
Fantastic idea! 😃👏
@ServusLibertate
8 ай бұрын
Fantastic, out of the box thinking at its best!
@MyOnlineTrainingHub
8 ай бұрын
Thank you 😊
@jerrydellasala7643
7 ай бұрын
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.
@MyOnlineTrainingHub
7 ай бұрын
Thanks for sharing 👍
@petercrowther5575
3 ай бұрын
Hi there. Can you create a QR code that will open a Document> Pdf, word etc.
@MyOnlineTrainingHub
3 ай бұрын
Yes, if that document is stored in a web enabled URL e.g. saved on OneDrive or a web server.
@4braKadabra
7 ай бұрын
What about logo inside the QR code? Do you know a way to create QR codes eith logo inside in bulk ?
@MyOnlineTrainingHub
7 ай бұрын
Good question, I don't know of any free ways to do this. Bit.ly allow you to with their paid service.
@walidmaamar
5 ай бұрын
The image function don't work for me, any tips ?
@MyOnlineTrainingHub
5 ай бұрын
Use the add-in instead.
@esrAsnataS
8 ай бұрын
This is excellent but sadly add-ins are locked at our company.
@MyOnlineTrainingHub
8 ай бұрын
You can create a QR code in Excel without add-ins.
@dorislo8671
6 ай бұрын
can this function on excel 2016?
@MyOnlineTrainingHub
6 ай бұрын
The add-in might be able to, but the IMAGE function is only available to Microsoft 365 users.
@sowjanyas3846
5 ай бұрын
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
5 ай бұрын
You could concatenate the text first e.g. =A1&B1
@sowjanyas3846
5 ай бұрын
@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
@MyOnlineTrainingHub
5 ай бұрын
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
Пікірлер: 89