How To Generate Single & Batch QR Codes With Excel [Free Download]

[@ExcelForFreelancers]

📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm

[@luisandeazevedo]

Great video tutorial! Do you have a tutorial where explains a QR Code device connected to the computer sending data to userform? If not do you recommend one?

[@ExcelForFreelancers]

HI and thanks. I do not have one currently and I would have to search for another. I will certainly consider it for a training in the future. Thank you for your Likes, Shares & Comments. It really helps.

[@BonnyGeorge]

Sir, can you make a tutorial on making a label(for printing) for my product with a qr/barcode code or based on Realtime data, for example for product A, if am having 10 numbers qr code should be somting like a------01,a------02,a-------03 etc

[@ExcelForFreelancers]

HI and thanks. I have that already within video series. You can just search my channel for "Label" I hope this helps and thanks so much.

[@uveshshaikh4423]

Hi, Thanks for this video, please can you help me further if I want to send this qr code through email, how can I do can you please explain or will love to see video of sending generated qr code through email please thanks

[@ExcelForFreelancers]

Hi and thank you can send it as an embedded html email (please search 'html email' on my channel) I hope this helps and thanks so much.

[@miicelltechnosv7395]

A great tutorial QR creator for Excel Advanced. Tks a lot

[@ExcelForFreelancers]

For sure, you are very welcome and happy to help. Thank you for your Likes, Shares & Comments. It really helps.

[@zolko8114]

Hello Randy! Is it possibble to create phone number qrs as well this way?

[@ExcelForFreelancers]

HI Zoltan, the QR code generated can accept any type of data, including phone #'s. I hope this helps and thanks so much.

[@mohamedelmadawy9806]

كنت بسأل على ان يكون Qr فعال مع الكميه بحيث مجرد عمل scan يتم تخصيم الكميه او جعل المنتج تالف لعدم الغش التجارى

[@ExcelForFreelancers]

HI and thanks so much. Thank you for your Likes, Shares & Comments. It really helps.

[@techsupport4180]

Randy, you are a star! Thank you for the video and master excel :)

[@ExcelForFreelancers]

You're very welcome, and thanks so much for your support.

[@dawnslater568]

Thank you for the video its great. Question, for the QRCode how would I get it to display information from E6, E8 & E14. All 3 instead of just the one cell?

[@ExcelForFreelancers]

Hi Dawn, thanks so much for your comment. You can combine the values in a single cell using CONCATENATE or other formulas and then link that single cell to the QR code or you can use VBA to combine all cell values into a single string variable. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@bikram903]

Sir how to generate qr code series 1 by 1 and show userform image1 Comando button1 click if textbox2 text 10 then Textbox1 sl no +1 and generate Qr code image1 and print next if textbox2 text 10 then 10time qr code generate+1 and 10 time print sir please help make 1 video

[@ExcelForFreelancers]

Hi and thanks very much. I have some videos on that. Please search "QR Code' to locate them. I hope this helps and thanks so much.

[@JohnMann858]

Great video, but how did you create the color palette?

[@ExcelForFreelancers]

Hi and thanks so much. This color palette is already part of Excel. I hope this helps and thank you very much.

[@MyQuimo]

I love this video.. I'm trying to make a QR code that will text automatically to the incase of emergency / Guardian contact number.

[@ExcelForFreelancers]

Hi and thanks, you are welcome to download this file and customize it however you like. I hope this helps and thanks so much.

[@stumiles86]

Yes! Finally. QR Codes. Just what I need. I have a solution using a website API but interested to see how you do it

[@ExcelForFreelancers]

Thanks so much. I hope you enjoy the training. The download will include several types of solutions.

[@lautarob]

Excellent (as all your videos used to be). This one I liked particularly because it is short.

[@ExcelForFreelancers]

Thanks yes this was an easy solution. Shorter ones are also easier for me too, sometimes if the solutions are easy I will try to make them that way. I was a bit pressed for time this week and this was an easy solution I could share. I always appreciate your comments.

[@paddordevpt2675]

@@ExcelForFreelancers Please send details of your mentorship program

[@petermayhew417]

Thx Randy, Although I have no desire to be an Excel Freelancer as a revenue generator, I was looking for a way to do batch QR code from data in a spreadsheet to use in one our our food ordering applications. Your template nailed it so thanks. I now need to figure out if text can be added to the QR code such as a person's name and the item description. I also need to be able to print these QR Codes onto labels to place on the food orders. Any help would be much appreciated. I would even pay for a custom template to meet our requirements. Peter

[@ExcelForFreelancers]

HI Peter, thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? [e-mail] Thanks so much.

[@petermayhew417]

@@ExcelForFreelancers just sent email. Thx for getting me in touch with someone to help.

[@shahzadisrani2616]

It is great but can we make coding on Button in Sheet1 for converting excel data from A2:D10 to png format & save in Folder as per mention in Cell B1 & Save name is mentioned in A1. Kindly suggest Thanks

[@ExcelForFreelancers]

Hi and yes you can save a picture based on any cell range. I show you how to do that here: kzbin.info/www/bejne/jYu7d2mue6mbfKc

[@pavankumar-mm7kp]

Hi Randy this is Pavan. I was completely trained based on your videos. Really thank you. Can we scan these QR codes with mobile?

[@ExcelForFreelancers]

Hi Pavan, thanks so much. The answer is yes, these QR codes can be read by any mobile device using the camera.

[@Bukhari1986]

how much should be charged from a customer for a normal project in excel what are per hour or per project approximate rates in market ?

[@ExcelForFreelancers]

Hi and thanks for your question. It really depends on the value you are offering to the customer. There is no min. or max on a per hour or per project basis. It all depends on value, project, budget and other factors. I hope this helps and thanks so much.

[@TheodorTV]

Hi Randy! is it possible to import the QR Code to your POS?

[@ExcelForFreelancers]

Hi yes its certainly possible using the methods I discuss in this training. You can tie the QR code to any assigned receipt #. I hope this helps and thanks so much.

[@NaveenKumar-sr9ff]

Good evening sir, sir I requested you to plz make a video on stock market, shares manegement format, candlestick pattern format, how to pull data from website, option chain analysis Excel sheet, stock maintenance sheet, fund manegement format

[@ExcelForFreelancers]

Thanks so much Naveen. I have added to to my list, however I will have to learn a lot about that before I can create an application for that. Thank you for your Likes, Shares & Comments. It really helps.

[@RTM-AMR]

बहुत बहुत धन्यवाद महाशय 🙏🙏

[@ExcelForFreelancers]

Thank you very much. I do appreciate that.

[@freemanrivera5227]

Hi Sir, Good day. This training is awesome. I do have one question though. Why the QR code being generated is too big on both GenerateSingleQRCode & BatchQRCode even though all my values are the same as yours in this video training. Thanks in advance.

[@ExcelForFreelancers]

Hi and thanks for your email. You an set the specific size of the QR within the API. The complexity of the QR will be based on the data being sent. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@niharikagaikwad2865]

Hi Randy! How to include other columns like description, unit price etc in the QR Code?

[@ExcelForFreelancers]

Hi and thanks for your comment. You can combine them into a single cell using the & or CONCATONATE or using VBA with a string variable then pass it into your webhook. I hope this helps and thanks so much.

[@niharikagaikwad2865]

@@ExcelForFreelancers So this would give me the results in a single cell after scanning the barcode. But I want them in different columns in my excel. How to do that? Is there any code for this?

[@ExcelForFreelancers]

Hi and thanks if the data starts in different columns, then you don't need to do anything, becuase they are already in different columns. You only need a new column to combine them for the bar code data. I hope this helps and thanks so much.

[@danstevenson3691]

Great video. My process is to create a packing list. The items on the packing list come over from another Excel sheet, automatically when selected by the user. When the item comes into the cell, I want to generate the QR code for that item in a column on that row. Is this possible?

[@ExcelForFreelancers]

HI Dan, thanks so much for your comment. Yes that is possible. When there is a change in a cell, you an use the Worksheet change event to run a macro. When that happens you can write a macro based on that specific change to that cell. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@danstevenson3691]

Thank you for your quick response. I will look up the group tonight and join.

[@willemmulder7304]

Great video, Randy! Veru intersting! Is it also possible to use this QR-code for in invoice? What information do you have to enter then? In The Netherlands it is more and more common to pay by scanning a QR-code.

[@ExcelForFreelancers]

HI and thanks very much Willem. This would work just fine for an Invoice as well. In the case of an Invoice all you would need to do is take the Invoice # and convert that to a QR code using the same code that I have within this application. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@knowledgeresourcellc3431]

Hi! I am trying to setup QR codes for member attendance. ie: have each member show their unique QR and it signs them in. I know I can do this in batch format, but which would be the best way?

[@ExcelForFreelancers]

Hi and thanks, you are in luck. I just released the Membership Manager yesterday that includes sign in/out with barcodes and can be used with QR codes as well here: kzbin.info/www/bejne/g6fHpWuOmd2UqJY

[@armandinejacotin9095]

You give great value - I appreciate it.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that jacotin

[@MahabubAlam-ek8be]

This is absolutely amazing advice

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Mahabub

[@BCook-pz6oy]

Hello All, Can I print the codes on an sheet and/or sticker? I was thinking a label print layout for the codes. Please let me know

[@ExcelForFreelancers]

Yes you can! Please follow this training video here: kzbin.info/www/bejne/bGO0l6x8gKulaMU (This is a 3 part series so make sure you watch all 3 parts) I hope this helps and thanks so much.

[@JoaquinVogt]

Hi Randy, this is an incredible tutorial. Thank you. I would like to save the QR codes as png. I imagine this can be accomplished through the Macro. What are your thoughts?

[@ExcelForFreelancers]

HI Joaquin, thanks very much. Yes it can be saved as a picture (not sure about png, but jpg for sure). If you create a chart then use this picture as the background to a chart you can then export it as a picture, and then delete the chart. I cover this method in this video, right around the 30 minute mark here: kzbin.info/www/bejne/jYu7d2mue6mbfKc I hope this helps and thanks so much.

[@JoaquinVogt]

@@ExcelForFreelancers Thank you very much! I'll take a look at it!

[@eamalttechsolutions7367]

Thank you! Helps a lot. Great content too.

[@ExcelForFreelancers]

For sure, you are very welcome and happy to help

[@FunMakers]

Waiting anxiously

[@ExcelForFreelancers]

Thank you so much Sajid :)

[@WilfriedVanElsen]

Hi Randy. Fine training. I had to reverse the color codes to make them match the doc and the color. (right is left and vive versa)

[@ExcelForFreelancers]

HI Wilfried thanks so much. I will update the file accordingly (or just change the descriptions) much appreciated.

[@Ro-zn6um]

Dear Sir, can you confirm that the QR codes that are generated this way are static (as opposed to dynamic). I believe dynamic codes could become worthless, depending on the company that issues or generates them. As I am planning to use 2,000 of these codes that will be in use at least 10 years and it will be a lot of work if we have to replace them in a few years..... (they will be printed on labels)

[@ExcelForFreelancers]

HI and thanks very much for the information. Thank you for your Likes, Shares & Comments. It really helps.

[@Ro-zn6um]

@@ExcelForFreelancers Eh.... this is a generic reply, but not an actual answer. Understandable, but disappointing nonetheless...

[@ExcelForFreelancers]

I provide multiple methods within the training and both are static and will not change once created as they are pictures. I hope this helps and thanks so much.

[@Ro-zn6um]

@@ExcelForFreelancers Hi, thank you for your specific answer. Sorry for confusing you. I did not mean that the picture of the QR code itself would change somehow. But it seems that a QR code can either contain information that cannot be changed (static) or it can contain a link to a database in which the information is stored (dynamic). While the link cannot be changed (the picture of the QR code stays the same), the data stored in the database can. Some companies earn money by generating QR codes for free, but they contain a link, not the information itself (I think this is how it works). At any point in time they can ask for money to keep the link to the information alive. And then you are up against the wall. So this is my actual question: do the QR codes generated in the way you teach contain the information itself (static), or do they contain that link that could in time start to cost money (dynamic)?

[@ExcelForFreelancers]

In this training, I go over two methods, 1 method to generate QR codes is without using any 3rd party tool, so it is important that you watch the entire video and download the free sample workbook. You own the code, the link, the picture, so nobody has control over anything but you. I hope this helps and thanks so much.

[@osamasaid8476]

thanks , you are a great teacher

[@ExcelForFreelancers]

Thank you very much. I do appreciate that Osama.

[@naamfcthefox71]

Good idea. Great. (from Thailand)

[@ExcelForFreelancers]

Kap Khun Ma Krub Khun Naam (kid thueng ahan Thai)

[@stumiles86]

Here we go!

[@ExcelForFreelancers]

Thanks for all the feedback and comments during the live chat. Make sure you download the workbook for more QR code options (non-api solutions) Those are faster but harder to customize and implement. (and a ton of code) :) So i went with the simpler option in the training.

[@letsgain9002]

Hey i luv the solution i try learning harder from your series, Happy guruji

[@ExcelForFreelancers]

Thank you very much. I do appreciate that. Thank you for your Likes, Shares & Comments. It really helps.

[@arnoldbencz6886]

Super job Sir! Thank You!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Arnold

[@arnoldbencz6886]

Hello. How should I modify in the VBA: QRData = .Range("E6").Value + .Range("E8").Value .... if I would like see on QR this lines,rows bellow?

[@ExcelForFreelancers]

Hi Arnold, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@martinbartlome136]

Hi Randy, the KZbin VDO is great. I am looking to purchase some pack you're offering particularly with the QR codes generator. Do you have a limited testing version you can share with me so I can see if it match my purpose? Cheers. Martin

[@ExcelForFreelancers]

Hi Martin, thanks so much for your comment, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.

[@jacquesmertens3369]

23:59 Is it possible that you meant charset-target instead of charset-target-?

[@ExcelForFreelancers]

HI Jacques, thanks for your comment. It is possible. You can double check with the API and follow their code precisely, which is where I got the details from. I hope this helps and thanks so much.

[@tejareddyjambuluru5427]

Hello sir we thought of doing attendence system using QRcode to scan QR code as well as face and then automatically the particular details of students should store in database. is these is applied for these.Can u plse give some suggestions

[@ExcelForFreelancers]

hi and thanks for your comment. I made a similar video on this as part of the Employee Manager. You can find that video here: kzbin.info/www/bejne/aqqYmIurZ9FphZI I will also be adding Timesheet feature to our School Manager series here: Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries

[@SyedMuzammilMahasanShahi]

Wow. That is awesome. Brilliant work as always... Thanks Randy.

[@ExcelForFreelancers]

Thank you so much Syed. I always appreciate your kind comments.

[@DanBrill]

This is really great. Exactly what I was looking for. Thanks for laying this out so clearly.

[@ExcelForFreelancers]

For sure, you are very welcome Dan, I am glad I can help.

[@zawwinaung626]

I am ready to learn it.

[@ExcelForFreelancers]

Thanks so much. I hope you enjoyed the video Zaw.

[@marcocervantes9340]

Hi Randy,I would like to know if there is any application in your book to assign tasks list to app mobile ?? I would like to see that application

[@ExcelForFreelancers]

HI and thanks very much. I have a Mobile Work Order Manager which allows the main application to create Work Orders which can then be filled out by the field staff and those details are automatically sent back to the main application. You can find the full training and download here: kzbin.info/www/bejne/j5LchGqEhcSrnbs Thank you for your Likes, Shares & Comments. It really helps.

[@Jdanible]

What would I need to adjust to have the QR Code pull up the picture associated with it.

[@ExcelForFreelancers]

Hi Jake, thanks for your comment. All you would need is the file path for the saved picture in order to open & display it. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@guitalelefan]

Thank you! Excellent training video, very helpful!!!

[@ExcelForFreelancers]

For sure, you are very welcome and thanks so much for your comment.

[@alkolff1031]

Hi Randy, Thanks QR codes linked to inventory could really cut the time to do the annual physical count that accounting requires. Sounds like another home run.

[@ExcelForFreelancers]

I agree Al. In this training I barely touched the surface. With around a 900 Character limit there is a ton of flexibility. Make sure you download the application since I included more QR code options in the download but they were a bit complex for the training.

[@omeralrshedi8543]

Thank you sir, I have benefited a lot from you How can data be encrypted, for example (tax number, trade name, total invoice amount, tax) Then read the code For example, in my field of work, I did this online coding:- AQ1BbGVzYXlpIEdyb3VwAg8zMDAwOTg0NDE4MDAwMDMDEzIwMjItMDMtMTNUMjE6MzU6NTkECDE0NDAwLjAwBQcxODc4LjI2

[@ExcelForFreelancers]

Hi and thanks you can use an encryption formula along with hidden columns, locked worksheets and workbooks, protected VBA and also encrypted code using XLSPadlock (bit.ly/SecureExcel) I hope this helps and thanks so much.

[@omeralrshedi8543]

@@ExcelForFreelancers Explanation of how the QRCode works in the electronic invoice hex - Base64

[@tobayekaina8610]

Hi Randy thanks for sharing. Can't wait to see

[@ExcelForFreelancers]

Thank you very much. I do appreciate that. Tobaye. I appreciate that.

[@เอยกับมะปรางรีวิว]

ช่องเทวดาชัดๆ

[@ExcelForFreelancers]

Kap Khun Ma Krub.

[@grahamparker7729]

Nice one Randy

[@ExcelForFreelancers]

Thanks so much Graham, This was a quick and easy one :)

[@brianbabulic9235]

Hi! Trying to setup a code where QRCodes are generated by a cell over and over again and creates a new code: For example: A B C Last Name First Name QR Code Smith John (SpecialQRCode) Doe Jane (SpecicalQRCode) Repeat Here is the code I currently have: But I don't need ForeCol or BackCol Sub GenerateSingleQRCode() Dim QRPic As String, QURL As String, QRDATA As String Dim QRSize As Long With Sheet2 On Error Resume Next .Shapes("QRItemPic").Delete On Error GoTo 0 QRDATA = .Range("B4").Value 'Item Name (QRData) QRSize = Sheet1.Range("B4").Value 'Large QR Size ForeCol = Right("00000" & Hex(Sheet1.Range("B3").Value), 6) ForeCol = Right(ForeCol, 2) & Mid(ForeCol, 3, 2) & Left(ForeCol, 2) BackCol = Right("00000" & Hex(Sheet1.Range("B3").Value), 6) BackCol = Right(ForeCol, 2) & Mid(ForeCol, 3, 2) & Left(ForeCol, 2) QRURL = "api.qrserver.com/v1/create-qr-code/?data=" & QRData & "&size=" & QRSize & "x" & QRSize &_ "&charset-source=UTF-8&charset-target-=UTF-9ecc=L&color=" & ForeCol & "&bgcolor=" & BackCol &_ "&margin=0&qrzone=1&format=png" With Sheet1.Pictures.Insert(QRURL) .Name = "QRItemPic" .Left = Sheet2.Range("C4").Left + (Sheet2.Range("M1").Width = .Width) / 2 .Top = Sheet2.Range("C4").Top + 5 End With End Sub ********** I don't really need anything regarding size but just a unique QRCode for each name that can autogenerate or paste *****

[@ExcelForFreelancers]

Hi and thanks for your question. I am sure its possible but one would have to test out your code and check the API. If you need help with this please post your issue in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.

[@manindermanu6597]

Hii. Am new in VBA . Please help me .

[@ExcelForFreelancers]

Hi and thanks for your comment. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/

[@jowhr99]

Can we add product name under the QR code?

[@ExcelForFreelancers]

Yes sure you can, the any type of data can be used with the QR code, You can just combine the screens with any unique delimiter, I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@princeofbajitpur9713]

Thanks

[@ExcelForFreelancers]

For sure, you are very welcome Thank you for your Likes, Shares & Comments. It really helps.

[@princeofbajitpur9713]

@@ExcelForFreelancers welcome sir

[@princeofbajitpur9713]

@@ExcelForFreelancers all video are very useful for me because after your video watch I am expert in excel in my college.👍

[@princeofbajitpur9713]

@@ExcelForFreelancers sorry sir my english is very poor. But I understand your video

[@czechyorker]

Great video. Thank you.

[@ExcelForFreelancers]

Thanks so much. This was a short one with a simple solution. Make sure you download the workbook to get more bar-code choices which I included in the workbook. :)

[@vocalchords3609]

Utterly fantastic! I really love your video - its almost as top notch as your competence, enthusiasm and wonderful ability to communicate and teach! Loved it! Thank you so much.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@InsideMyWall]

How to export data to a excel spreadsheet after scanning a QR code??

[@ExcelForFreelancers]

HI and thanks for your comment. I have a series on this channel called 'Import Manager' which should help you with that here: kzbin.info/www/bejne/jpjYaZZqZbuHerc

[@BestFriendsForeverTrue]

I wonder how to put msgbox while generate qr code (if no internet connection on computer I want to put msgbox: no internet connection on your device please try again) how about the code?

[@ExcelForFreelancers]

Hi and thanks you can do something like MsgBox "No internet connection is available at this time" I hope this helps and thanks so much.

[@BestFriendsForeverTrue]

@@ExcelForFreelancers Thanks

[@scotsrule08]

Great stuff as always!

[@ExcelForFreelancers]

Thanks again Spencer. I really appreciate that.

[@taylorej5556]

Question: my link is 260 characters long. Looks the QRcode this API generate it doesn't include all the characters in the URL. Any advice for this problem? when I scan the QR code I get about 79 characters from the 260 I am suppose to get

[@ExcelForFreelancers]

Hi Taylor, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@restoration2489]

This is the first time I know your channel. Can i make friend with you

[@ExcelForFreelancers]

Thanks so much. Glad to have you here.

[@astudentsartjourney3988]

When I generate the QR codes excel shows 'the imagine cant be displayed.' How do I fix this?

[@ExcelForFreelancers]

Hi and thanks you can check the API code or you can step through the code using F8 to find the issue with the picture generation I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@user-MOHAMMED-AL-BDIRI]

توجد مشكلة عند عمل ال qr code في sheet واغلاقه لاتظهر ال qr الا بوجود خدمة الانترنت

[@ExcelForFreelancers]

Hi and thanks so much. You can save the picture to a file on your computer, once the QR code is created and therefore you would not need an internet connection again. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@alfredreloj683]

This is very useful :)

[@ExcelForFreelancers]

Thanks so much Alfred, I am glad I can help

[@muhammadbarznji7786]

that is amazing 😍, thanks for share that 👍💖.

[@ExcelForFreelancers]

Thank you! Cheers! I appreciate that Muhammad.

[@adchrisakinyode5087]

Hi Randy, I followed your training and I configured every code according. But I get error "An error occurred while importing thus file". I downloaded the file itself from your site but I still get the same error. Kindly, help....

[@ExcelForFreelancers]

Hi Adchris, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.

[@adchrisakinyode5087]

Sure... Will do that.

[@guilhermerodrigues6214]

Excelente!

[@ExcelForFreelancers]

Gracias Guilherme :)

[@BestFriendsForeverTrue]

How to save all qr code as png in computer?

[@ExcelForFreelancers]

Hi and thanks so much, you can create a chart and set the picture as a chart background then save it as a picture. I show you how to do that here: kzbin.info/www/bejne/jYu7d2mue6mbfKc I hope this helps and thanks so much.

[@ggmtddbo]

Great! Thk! !!

[@ExcelForFreelancers]

For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.

[@boroboro4294]

Thank you! You are a Hero for this! I mean it!

[@ExcelForFreelancers]

Thank you very much. I do appreciate that Shai.

[@mohamedgamal433]

can i have this templet for free Thanks

[@ExcelForFreelancers]

Hi Mohamed, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

[@deepsharma78912]

hi sir where is the excel file?

[@ExcelForFreelancers]

Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.

[@ihtashamzafar6713]

HI SIR I NEED SCHOOL MANAGEMENT SYSTEM IN EXCEL. KINDLY SHARE THE FILE OF MAKING SCHOOL MANAGEMENT SYSTEM

[@ExcelForFreelancers]

Hi and thanks. I do not have this application as it is a large application and would require a developer for hire to create it. Please feel free to post a PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.

[@AI-ec2qb]

@@ExcelForFreelancers hahahaa you replied with the best to this leech, I cant stop laughin. Good answer. I hate when they use the word 'Kindly'

[@azelbeckner6116]

Read QR code

[@ExcelForFreelancers]

Hi and thanks, Any QR code scanner can read QR codes. I hope this helps and thanks so much.

[@nartanr15]

How to download this particular workbook ?

[@ExcelForFreelancers]

Hi the links will be available on video launch. Thank you.

[@haba.abogazia9562]

🙏

[@ExcelForFreelancers]

Thank you for your Likes, Shares & Comments. It really helps.

[@tcvesim1948]

Waw waw waw

[@ExcelForFreelancers]

Thanks so much. I hope you enjoy the training. This is a short one you will enjoy :)

[@nadhraAdhra]

Please check out your email sir, I have few question to ask regarding this! Thanks in advanced!

[@ExcelForFreelancers]

Thanks so much. Yes i got your email and responded already. Much appreciated.

[@ellisdean]

Thanks very much. Fantastic stuff.

[@ExcelForFreelancers]

For sure, you are very welcome, I am glad you enjoyed the training.

[@nel9076]

Thank you so much for your videos!

[@ExcelForFreelancers]

For sure, you are very welcome Jannellee, I always appreciate your kind comments.