[message type=”warning”]Disclaimer: The information contained on this page forms part of my GPC CPD portfolio and is therefore my personal opinion and in no way reflects the opinion or policy of my employer.[/message]
[message type=”custom” start_color=”#ffffff” end_color=”#DFF2BF” border=”#999999″ color=”#333333″]
Introduction
In addition to expanding my knowledge of barcode systems, the aim of this learning exercise was to create a very simple spreadsheet application that would contain a list of EAN13 codes, which could then be printed on to labels so that they could be attached to product packs that were not supplied with a barcode label. This allowed these additional products to be scanned into an automated product storage and retrieval system.
[/message]
[divider_top]
[message type=”custom” start_color=”#ffffff” end_color=”#DFF2BF” border=”#999999″ color=”#333333″]
Requirements
[custom_list style=”list-1″]
- Excel 2007 or above
- EAN13 barcode font (ean13.ttf) installed on each PC that you wish to open the spreadsheet.
- Label printer
- This project uses code and font provided in the “barcode fonts and encoders” distribution available on Sourceforge.
[/custom_list]
[/message]
[divider_top]
[message type=”custom” start_color=”#ffffff” end_color=”#DFF2BF” border=”#999999″ color=”#333333″]
Instructions for use
- Download the Barcode-Creator.zip file here and then unzip the file
- Go to Start>>Control Panel>>Fonts
- Click File>>Install New Fonts…
- Navigate to the location that you unzipped the parent “Barcode-Creator” folder and select the ean13.ttf
- Open the Excel Spreadsheet
- A security warning bar will appear – Click: Options>>Enable this Content>>OK
- The Barcode Creator tool is made up of two sheets “BarcodeCreator” and List.
- To add a product and barcode to the system, navigate to the “List” Spreadsheet.
- Enter the product description in column A and then the first 12 digits of the chosen EAN code in column B. (The last digit is the check digit and is calculated – once you know what it is you can add it to column C).
- Once you have added the entry in the “List” spreadsheet, make sure you save your changes.
- Go back to the “BarcodeCreator” sheet and then select the product from the dropdown list.
- On selection, four barcodes will appear to the right (I required 4 identical barcodes to be printed on one 760mm x 380mm label, although you can modify to suit your own purposes by adjusting the print area).
- Click on the “Print” button.
- The print area will be shown in print preview. You may need to modify the paper size and orientation settings to suit your requirements.
[/message]
[divider_top]
Screenshots



[divider_top]
Review of Background Knowledge
[message type=”custom” start_color=”#ffffff” end_color=”#DFF2BF” border=”#999999″ color=”#333333″]
Barcode Quiz
[/message]
[divider_top]