barcode

  1. J

    Concatenated the values of cells in same cell but keeping the font of the last cell as free30f9(barcode)

    Hi, the objective of my project was to generate labels from an excel file which will be downloaded from ERP software. With the help of mr excel i was able to do everything that I wanted to and even generate the labels. Now the final nail in the coffin is that the cell G which contains the...
  2. N

    Auto-Activate Workbook when using a Barcode Scanner

    Good Morning Everyone (at least whenever I am first posting this), I have made a barcode scanner userform that acts as a small inventory system for my company. Nothing special but it gets the job done. Basically the inventory employee would scan a specific parts' barcode, and a TV display will...
  3. N

    Barcode Notification System

    Hi all, I work for a small manufacturing company, and I have been tasked with setting up a barcode system. I am not trying to setup an inventory management system, I do not need to keep track of any quantities (or at least as of right now). I could see the system wanting to be expanded into...
  4. M

    Function =now() in barcode format

    Hi I am working on a data sheet for users, the idea is to capture the current date & time by scanning an external laminated barcode, there are various activities happening in the room, and, as and when a particular activity is completed, the supervisor scans a barcode (the barcode remains the...
  5. X

    extracting a small piece of bar code with scanner and input into excel

    Hello folks, I have just got a project dumped in my lap and I need help ASAP. I have a Kercan scanner and I need to scan a specific bar code that has 80 characters. I need to only extract characters 35 - 39, they are the quantity of the item. I have looked and cannot find any help on this...
  6. J

    Task Tracking w/ barcode scanner

    I'm looking for help with an excel function/macro that could use a barcode scanner to first scan the ID badge and then next an "activity" barcode (ex, shipping, packing, etc..). When the ID is initially scanned I would like the current time to be automatically entered. Next, when the barcode...
  7. F

    Barcode to auto save workbook

    Guys!! I do need to save a workbook by only reading a barcode. I mean as I read a barcode it will save automatically the workbook. Is it possible ? Please help me out . .. or does somebody has already done it cause I couldn't find a link talking about it.
  8. F

    How to creat a macro to generate a barcode in excel by clicking a button?

    Hello, I am using microsoft office excel 2013. I have googled everything I can think of and all I can find are ways to create barcodes from numbers I type in. I am trying to see if it is possible to generate barcodes with random numbers so that it will not create duplicate barcodes. Maybe if it...
  9. Q

    Barcode Image Intrepretation method

    I would like to take a bar code image file in a .jpg format and return a text value via a subroutine or function in VBA. Any help would be greatly appreciated in terms of code snipets, weblinks and/or reference libraries.
  10. H

    External Barcodes

    Hi All, I need to insert barcodes into an existing excel macro, however this issue I have is the company I work for won't put any excel barcode softare on the PC's for us to use. Is there a way I can somehow link it to an external free barcode website e.g. Barcode-generator.org or...
  11. U

    Stock control using handheld barcode scanner

    I have been tasked with a project to create an Excel sheet for Stock Purposes. I have a Wired Handheld Scanner, and I have been able to scan a Barcode to Excel, and for it to show up in the selected Cell. I have the following Columns in my Excel Sheet; Column A = Barcode (in text form) Column B...
  12. J

    Generating barcodes within in Excel

    Hi All, I need some advice. I am want to generate barcodes for line items recorded in an existing excel 2010 workbook. I came across the below code online. It works fine in the excel document I download online but when I try to get the VBA code to work in my own workbook, it does nothing...
  13. B

    Barcode Scan into specific sheet of excel

    Hi, i was wondering if anyone knew how to or if it is possible to set a scanner to scan barcodes into a specfic sheet, column or row in excel whole cursor is on another? Meaning you would set the scanner to scan the barcode in spot and could be working on the document somewhere else - currently...
  14. P

    Barcode Scanner to reduce quanitity

    Hello, I am hoping I will find my answers here as combing the internet has not gotten me to the answers I need. I currently have a spreadsheet with all my products and quantities, and I am updating manually each day which is a pain. My products have sku numbers in this excel sheet and i am...
  15. M

    Barcode scanning database

    Hi there! I need a lot of help: I need to be able to scan a brcode into a single cell (one that is frozen at the top of the spreadsheet), have excel find that serial number in a list of serial numbers, enter a check mark into the adjcent cell and a date and time stamp adjcent to that. Please if...
  16. S

    Barcode Scan; Remove extra characters & add a date and timestamp

    Hello, I'm new to the forum, but I use the site for help all the time. Usually I am able to figure it out based on other issues threads, but this one has me stumped. I am looking to run two subs, one to remove extra characters on the barcode scan itself (see below for code). Private Sub...
  17. A

    Simple Inventory set up with barcode scanner

    Hello, We are using Windows 7 and Excel 2013. We also have a Honeywell Hyperion 1300g barcode scanner. We are a small (5 employee) family owned auto repair shop. We need to create a simple inventory tracker system so we know how much of each part we have in stock. I have a list of 400+ item...
  18. M

    Barcode formula extract/formatting

    my apologies but I can't find this in any other thread-. Perhaps I'm searching for the wrong words. im dealing with barcodes that have these check digits. Scanner is picking up this barcode (01)4583967589324(17)130420(21)45443 without the parenthesis. what formula can I use to say read the...
  19. C

    Barcode Scan -Print automatically

    Problem: I'm trying to use a USB barcode scanner to scan a barcode into excel and autoprint the number value. Is there a simple efficient way to do this using excel? If not what can you suggest? I've trawled the net, but keep being sidetracked to irrelevant avenues regarding stock/barcode...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top