« »

Generate Code 128 barcodes from excel

June
4
member
sucotronic

code_128

If you look for how to generate Code 128 barcodes from excel excel through internet, you will find with lot of companies that sell proprietary products to make this kind of codes, but is not easy to find a free tool to do the job… however they exists. At sourceforge there is a project called ‘openbarcodes‘ that give us all the resources to make them, and of course they are free.

The steps to follow are the following:

  1. Download this file, it contains the font used to write the barcodes:
  2. Extract the file code128.ttf in the folder FONTS of Windows (normally “C:\WINDOWS\Fonts”). In my case it is at:
    carpeta_fonts

  3. Download the following excel file that contains the macro necessary to generate the Code 128 barcodes with checksum, without this checksum the scanner can’t read the data correctly.
  4. In the column A you have to enter the numbers (or string) to encode, and in colunm C will appear the encoded barcodes. The column B is hidden because it’s used to make some calculations.

    excel_code128

Source: grandzebu.net


date Posted on: Thursday, June 4, 2009 at 22:36 pm
Category Uncategorized.
Puedes seguir las respuestas de esta entrada a traves de l feed RSS 2.0.

Puedes dejar una respuesta, o trackback desde tu propio sitio.



Escribe un comentario


a trastear un poco is powered by WordPress
Theme is Coded&Designed by Wordpress Themes at ricdes