+ Reply to Thread
Results 1 to 16 of 16

Generate QR code in Excel

  1. #1
    Registered User
    Join Date
    10-30-2018
    Location
    Cape Town, South Africa
    MS-Off Ver
    MS office 2013
    Posts
    3

    Generate QR code in Excel

    Hi guys. I'm an Excel beginner and I have to set up instructions on how to generate QR codes within Excel.
    I searched with google and get a lot of hits that require add-ins to be used.
    Can anyone recommend a reliable free add-in?
    Or is there a way for noobs to insert QRcodes that do not involve difficult programming? [I don't even know what macros are ]

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Generate QR code in Excel

    ByteScout has a free to use barcode (QR) generator.
    I read that it also has a free to use (non-commercial use only) to use with Excel.
    Check their site
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Generate QR code in Excel

    See https://www.excelforum.com/excel-gen...code-font.html or https://www.mrexcel.com/forum/excel-...des-excel.html
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    10-30-2018
    Location
    Cape Town, South Africa
    MS-Off Ver
    MS office 2013
    Posts
    3

    Re: Generate QR code in Excel

    Quote Originally Posted by Keebellah View Post
    ByteScout has a free to use barcode (QR) generator.
    I read that it also has a free to use (non-commercial use only) to use with Excel.
    Check their site
    Thanks; will check it out!
    Last edited by attrahent; 10-31-2018 at 02:59 AM.

  5. #5
    Registered User
    Join Date
    10-30-2018
    Location
    Cape Town, South Africa
    MS-Off Ver
    MS office 2013
    Posts
    3

    Re: Generate QR code in Excel

    Quote Originally Posted by shg View Post
    See links
    Thanks for posting but as I mentioned I'm a beginner - have no clue what I'm supposed to do with the provided code

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Generate QR code in Excel

    I implemented the code that was posted.

    Try, read the code and learn, it's all about time, patience imagination a lot or practice
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-28-2019
    Location
    mexico
    MS-Off Ver
    2016
    Posts
    2

    Re: Generate QR code in Excel

    What kind of changes i have to do to the excel file to create VCARDS qr codes, i need more lines of information instead of just one... help please

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Generate QR code in Excel

    Quote Originally Posted by ozzgzz View Post
    What kind of changes i have to do to the excel file to create VCARDS qr codes, i need more lines of information instead of just one... help please
    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  9. #9
    Registered User
    Join Date
    08-09-2018
    Location
    kuala lumpur
    MS-Off Ver
    2016
    Posts
    1

    Re: Generate QR code in Excel

    Hi,

    Thanks for the code..
    It helps me much..
    How to make it generate the QR if its hasn't generate yet if its already generate skip to next cell.

    Thanks in advance.

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Generate QR code in Excel

    Quote Originally Posted by adx3660 View Post
    Hi,

    Thanks for the code..
    It helps me much..
    How to make it generate the QR if its hasn't generate yet if its already generate skip to next cell.

    Thanks in advance.
    Perhaps you missed my post DIRECTLY above yours?

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

  11. #11
    Registered User
    Join Date
    04-01-2020
    Location
    Midland
    MS-Off Ver
    365
    Posts
    1

    Re: Generate QR code in Excel

    Thanks for sharing.

  12. #12
    Registered User
    Join Date
    06-22-2020
    Location
    Poland
    MS-Off Ver
    Office 365
    Posts
    1

    Re: Generate QR code in Excel

    Hi Keebellah,

    You saved my life

    Thank you for sharing!!

  13. #13
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Generate QR code in Excel

    You're welcome. Glad it helped

  14. #14
    Registered User
    Join Date
    09-08-2020
    Location
    Eindhoven, Nederland
    MS-Off Ver
    Excel 2016
    Posts
    1

    Re: Generate QR code in Excel

    Thank you for charing this code, am trying the use of it.

    Regards Marcel

  15. #15
    Registered User
    Join Date
    11-22-2020
    Location
    USA
    MS-Off Ver
    O365
    Posts
    2

    Re: Generate QR code in Excel

    Thank you for sharing, the code works perfectly other than one of my cell has & and the QR code doesn't recognize &. Any suggestions on how to update the code?

  16. #16
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Generate QR code in Excel

    Quote Originally Posted by some111 View Post
    Thank you for sharing, the code works perfectly other than one of my cell has & and the QR code doesn't recognize &. Any suggestions on how to update the code?
    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-24-2018, 10:56 AM
  2. [SOLVED] VBA code to feed inputs row by row into a Excel modeller and generate corresponding output
    By excel_msa in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-12-2017, 08:50 AM
  3. [SOLVED] Generate random Code consist of number and letter using VBA code
    By mazan2010 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-27-2017, 11:03 AM
  4. Generate new commodity code
    By COGICPENNY in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-20-2015, 04:51 PM
  5. [SOLVED] VBA code to generate Y or N in cells
    By Jim885 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-07-2013, 09:55 PM
  6. Excel to generate a code
    By chidmas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2012, 12:24 PM
  7. [SOLVED] VB code to generate an e-mail with an EXCEL attachment, but not se
    By MJ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-17-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1