The reason for these codes to be more useful is because of its capabilities. QR can store much more data as compare to Barcodes such as site URLs, text messages, numbers, geo coordinates etc.
Yes, it is possible to generate QR Codes using Excel. Since it is bit complex; hence we have taken simpler approach for explanation. We are making use of Web API provided by https://api.qrserver.com to generate the QR code.
Step 2: Open the tool an you will see below screen
Note: Since this file includes Macros; hence you need to enable macros if Excel prompt you to enable it. See below a sample screenshot of Excel warning message. You need to click on Enable Content
Step 3: Click on ‘Clear Data’ button
Step 4: In column A (Content/Text/URL etc.), enter the content you want in the QR code. This can be your site address, any text, alphanumeric number etc.
Note: This copy of tool can generate up to 10 QR Codes at a time
Step 5: In column B (Font Color), change the cell color in which you want the QR code
Step 6: In column C (Back Color), change the cell color in which you want QR code back color
Step 7: Click on ‘Generate QR Code’
Step 8: Tool will now send text, font and back color details to https://api.qrserver.com and paste the QR code provided from the site in column D (QR Code)
Note: Since the tool is getting the QR code from the site; hence please ensure that you are connected to internet before using the tool. Also, you must have access to https://api.qrserver.com. Sometimes due to slow site response or internet issues, you may receive few error messages. Just click on OK and try again.
We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion
This course is going to help you to excel your skills in Excel VBA with our real time case studies.
Lets get connected and start learning now. Click here to Enroll.
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community
Working with huge data is always exciting and challenging. From 2007 version onward, Excel is supporting more than a million rows in each worksheet. One of the common problems with huge data is “Duplicates” and the bigger problem is to identify and remove these duplicates. In this article, we will be sharing 4 ways to delete duplicate records from your data.
Dummy Data Generator is an MS Excel based tool which has capability of generating 45 types of data which includes numbers, text, date, time, Memo (long text), Boolean etc.
Outlook Bulk Email Tool is an Excel and Outlook based tool which helps you to send or draft email in bulk right from Excel. It reads the recipient details from Excel sheet and uses Outlook installed on your system to generate emails. The tool supports To, Cc, Subject, Email Body, Attachment, HTML Table in Email Body.
VBA Code to list Files in Folder To work on multiple files through VBA programming, you need to have VBA code that can list files in a folder. Here is a simple code for you,…
Duplicate Data Identifier is an MS Access based tool which helps to identify duplicates from any Excel based data. The tool supports up to 10 conditions and 25 types of matching conditions to find the exact duplicate. You can also define formatting conditions to first format the data before checking for duplicates.
Duplicate Files Finder Tool is an MS Excel based tool to identify duplicate files exist in your system or shared folder. The tool takes a base folder path as input and list down all duplicate files in the folder and sub-folders. It has capability to find duplicate files by comparing the names and their size.