+ Reply to Thread
Results 1 to 13 of 13

barcode scanning

  1. #1
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    barcode scanning

    I have a sheet that I use to track job time using a simple barcode scan that time stamps the scan in and out. I am looking to add more information to the job for tracking but don't want to do multiple scans if it's not required.
    How can I take l following example of barcode text and have it go into separate cells with one scan.
    Thanks

    25478 Smith 55
    three separate columns one barcode
    Southwest Granite & Glass
    Quality, It's what we do
    http://www.swgg.ca

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,468

    Re: barcode scanning

    Hi,

    Perhaps a Sheet Change event macro that reacts to the scanner populating a cell or cells on the sheet. The macro should parse the string you show into three columns.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: barcode scanning

    thanks Richard.
    This is the code i am running now. How wold it interfere or would it?

    Please Login or Register  to view this content.

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,468

    Re: barcode scanning

    I need to understand the current process a little more,

    Are you saying that the 3 element string you mention in post#1 is currently arriving in column 1 as a Start Scan and if the scan is a stop scan this goes into column 5, and the macro is then adding the date & time to columns 2 & 3, and that the requirement is to split the 3 element string to three separate columns?

    It would be useful if you could upload the workbook with some example scan detail rows showing different values (and permutations of entries if that's at all relevant), and then manually add the results you expect to see after some new code parses the string. I see the new code as an addition to the existing macro but need to understand which of the IF..End If blocks of code should be the trigger.

  5. #5
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: barcode scanning

    I have attached the workbook. I have used the austin tab to show how I would like the results to now appear breaking a single scan into three cells

  6. #6
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: barcode scanning

    sorry this site is messed i keep getting kicked off before upload completes i will try later

  7. #7
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: barcode scanning

    try this time
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    08-09-2012
    Location
    British Columbia
    MS-Off Ver
    Excel 2010
    Posts
    188

    Re: barcode scanning

    Appears you would be scanning into column B for START or G for STOP.
    Try this...
    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: barcode scanning

    works perfect thanks

  10. #10
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: barcode scanning

    sorry nosparks is there an option for the last section of the three in the scan to be formatted as a number. Its formatting as text now and if i try to format the cells prior to to data transfer it just switches it back. I need to average out that last column
    thanks

  11. #11
    Forum Contributor
    Join Date
    08-09-2012
    Location
    British Columbia
    MS-Off Ver
    Excel 2010
    Posts
    188

    Re: barcode scanning

    No need to be sorry.
    Every project undergoes revisions.

    See if this works as needed.
    Code is only with the Austin sheet.

    Looking at your 'Data' sheet, the client name/number are not always in the same order and I assume the end number is yet to be inserted in the bar codes.
    Are LUNCH, BREAK and YARD typed in manually?

    Good Luck
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: barcode scanning

    Quote Originally Posted by NoSparks View Post
    No need to be sorry.
    Every project undergoes revisions.

    See if this works as needed.
    Code is only with the Austin sheet.

    Looking at your 'Data' sheet, the client name/number are not always in the same order and I assume the end number is yet to be inserted in the bar codes.
    Are LUNCH, BREAK and YARD typed in manually?

    Good Luck
    YARD, BREAK & LUNCH are scanned as well. I have corrected the order issue so all future scans will be invoice number, client surname, sq footage. It's the sq'# that i needed to do calculations on. New code seems to woork ok. My old scans only have two and there are a few of those to go through the system. So far this morning those old ones are placing # in cell b2 and b4. we'll see how that plays out at end of day when i transfer data.

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

    Re: barcode scanning

    deleted my post
    Last edited by FDibbins; 02-01-2017 at 04:22 PM.
    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

+ 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. Barcode scanning help
    By abirup in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-10-2016, 04:36 AM
  2. Barcode scanning
    By abirup in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2016, 08:39 AM
  3. VBA barcode scanning
    By JoboM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2015, 02:30 AM
  4. [SOLVED] Check barcode scanning
    By intex in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-25-2015, 02:23 PM
  5. [SOLVED] Issues with barcode scanning
    By qmccain in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-31-2015, 01:34 AM
  6. barcode scanning template
    By donkey_uk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2013, 12:19 PM
  7. Barcode Scanning - Library
    By _LG_ in forum Excel General
    Replies: 1
    Last Post: 12-05-2011, 11:55 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