New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions Bookmark and Share
FulanoNadie

How to setup an Excel sheet for scanning and instant barcode generation

We have the need to setup a simple input/output scenario. We need to scan 1D (linear) barcodes directly into Excel and use your 1D (linear) barcode fonts to generate the barcode equivalent barcode next to it, with the default options.

Requirement: Each row will have a new barcode entry.
How do you advise we set this up?

Compatible Products:
· Native Barcode Generator for Excel
· Font VBA for Excel
· 2D QR-Code | DataMatrix Barcode Font for Excel
· USB Barcode Scanner

Operating System: Windows, Mac

Application: Windows Excel or Mac Excel (2004, 2011+)

11-19-13     2043 day(s) ago    

  Report Abuse

 

James

Best Answer

Update: A new product (Native Barcode Generator for Excel) has been released since this post was resolved that offers an easier method of generating barcodes in Excel.

Since the goal is to generate the equivalent barcode (with default options) automatically, the use of the VBA will be the font encoding option covered. Code 128 is a commonly used barcode-type (symbology) and will be used in the tutorial. The scanned data will not contain any special formatting.

1. Attach the VBA font encoder, as described, to the worksheet being used:



2. Setup the column for text formatting before scanning (using Column A as the 'scan-in' column):

image

3. Setup the first cell's formula:

image

4. Assign DataToFormat to cell where it comes from (do not assign other fields):

image

5. For now, the result will show as #VALUE!, which is expected.

6. Setup the IF clause to make up for no data in the A2 cell yet. Copy the following into cell B2:

=IF(A2="","",(Code128(A2)))

Which means:

* If A2 is empty, show blank.
* If not empty, show the barcode.

The sheet will look like this with B2 selected, showing the formula and B2 looks empty:

image

7. Apply the Code 128 Font to cell B2. For this post, we will be using the recommended Medium font at 12 point, named as:

* Demo: IDAutomationSC128M
* Purchased: IDAutomationC128M

8. Copy the formula in B2 to the rest of the cells in Column B (by copying down, Excel automatically adjusts each formula):

image

9. If the scanner being used has custom programming, it might interfere with expected behavior. It is suggested that the scanner be reset and reinitialized (see your scanner manual). In this example, the IDAutomation SC7-USB-2D Scanner will be used:

* To reset SC7-USB-2D to defaults, scan the "Reset Scanner to Default Settings" barcode from the Reset.

*To initialize SC7-USB-2D, using the default mode (USB HID), scan the respective barcode.

10. Place your cursor, without clicking anywhere else, on the Excel spreadsheet (cell A2) and begin scanning Code 128 barcodes until you reach the cell you last pasted the formula in step 8:

image

* Step 8 may be repeated if more cells in column B are needed

If it is desired to generate images instead of using a font, refer to the Native Barcode Generator for Excel.

Posted 2043 day(s) ago

()
()
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.

Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2019 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook