+ Reply to Thread
Results 1 to 10 of 10

QR Code and data entry in Excel

  1. #1
    Registered User
    Join Date
    11-06-2021
    Location
    Limerick
    MS-Off Ver
    2016
    Posts
    36

    QR Code and data entry in Excel

    Hi all,

    Can anyone advise if by scanning a qr code, information can be entered in an excel spreadsheet? And how can one achieve this?

    Thanking you,

    Kind regards,
    Magic

  2. #2
    Valued Forum Contributor
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    2016 & 365 Sub
    Posts
    906

    Re: QR Code and data entry in Excel

    Do you have a scanner that can scan QR codes plugged into the computer?

    How do you plan to link the device scanning to Excel?
    If things don't change they stay the same
    Quite often there is a picnic problem (problem in chair not in computer)
    "We were not told it was impossible, so we did it."

  3. #3
    Registered User
    Join Date
    11-06-2021
    Location
    Limerick
    MS-Off Ver
    2016
    Posts
    36
    Quote Originally Posted by CheeseSandwich View Post
    Do you have a scanner that can scan QR codes plugged into the computer?

    How do you plan to link the device scanning to Excel?
    With a QR reader app?

  4. #4
    Registered User
    Join Date
    11-06-2021
    Location
    Limerick
    MS-Off Ver
    2016
    Posts
    36

    Re: QR Code and data entry in Excel

    The qr code would be scanned by the phone, through a qr reader app?

  5. #5
    Valued Forum Contributor
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    2016 & 365 Sub
    Posts
    906

    Re: QR Code and data entry in Excel

    How is the app connected to the computer running Excel? or are you referencing Excel on a mobile device?

  6. #6
    Registered User
    Join Date
    11-06-2021
    Location
    Limerick
    MS-Off Ver
    2016
    Posts
    36

    Re: QR Code and data entry in Excel

    If having a fleet of buses, one could scan the qr code inside the bus and enter the mileage at the time?

  7. #7
    Valued Forum Contributor
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    2016 & 365 Sub
    Posts
    906

    Re: QR Code and data entry in Excel

    If it is a mobile device then i believe there are addins & apps that can be used, that is if you want the data to go to a desktop computer from the phone.

    https://appsource.microsoft.com/en-u...6?tab=overview

    https://www.scansku.com/pages/micros...canner-scansku

    https://www.lomag.eu/ScannerAndroid/

    Might be worth writing a bit more detail on what the end goal is: What is scanning the data, what is recieving the data, mobile, desktop, mobile & desktop etc...

  8. #8
    Registered User
    Join Date
    11-06-2021
    Location
    Ireland
    MS-Off Ver
    Office 2017
    Posts
    1

    Re: QR Code and data entry in Excel

    Thank you.



    My idea was that I would generate individual QR codes for each bus, then I will have these displayed inside the bus, next to the driver, and when the driver is finished their shift, they would scan the qr code using their phone, which will bring them to this document or excel where they would be able to enter the mileage at the time, with the current date and time as well.



    Is this something that can be achieved through VBA in Excel?

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,241

    Re: QR Code and data entry in Excel

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

    (Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
    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

  10. #10
    Registered User
    Join Date
    11-06-2021
    Location
    Limerick
    MS-Off Ver
    2016
    Posts
    36

    Re: QR Code and data entry in Excel

    Apologies, I wasn't aware that cross-posting would create such issues. Fyi, one of the websites is not accessible from my work system, while the other is. This is why I have cross-posted it.

    Anyway, here is the link for the other site.

    https://www.mrexcel.com/board/thread.../#post-5981300

    Magic

+ 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. [SOLVED] Add Data Entry Queries to VBA Code
    By bluemanuk1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-16-2022, 08:26 AM
  2. [SOLVED] Data Entry Form VBA Code
    By drewtom in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-19-2019, 11:13 AM
  3. bar code data entry
    By aby-geek in forum Excel General
    Replies: 1
    Last Post: 04-20-2016, 07:28 AM
  4. Replies: 0
    Last Post: 02-04-2014, 12:36 AM
  5. [SOLVED] Userform data entry code
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 18
    Last Post: 12-21-2013, 12:48 AM
  6. Replies: 1
    Last Post: 11-13-2012, 02:06 PM
  7. VBA code to prevent data entry
    By singhabhijitkumar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-04-2010, 03:42 AM

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