Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Trapper
 
Posts: n/a
Default How to create barcodes in excel?

In setting up an inventory worksheet, it would be very helpful to have
product numbers (SKU) in barcode format for scanning. Is it possible to
create barcodes within Excel?
  #2   Report Post  
 
Posts: n/a
Default

hi,
yes. barcodes are just another font. excel uses 3 of 9
barcode. Other barcode fonts can be downloaded from the
net.
formatcellsfont tabat the top of the font list.

-----Original Message-----
In setting up an inventory worksheet, it would be very

helpful to have
product numbers (SKU) in barcode format for scanning. Is

it possible to
create barcodes within Excel?
.

  #3   Report Post  
Thomas Lutz
 
Posts: n/a
Default

A bar code is generally more complex that just changing the font.
Bar codes contain special start and stop patterns and most types of
bar codes also use a very complex algorithm for producing the correct
bar/space pattern in the bar code for a given message being encoded.
The only type of bar code that can be implemented using a font without
having to write any code to process the message data first is Code 39
and even with Code 39 you still need to include start and stop
characters (usually an asterisk) at the beginning and the end of the
message before changing its font to a bar code font.
Even after you do this, you will still end up with a very low quality
bar code that may or may not read depending on a number of factors
(printer resolution, font size, how good your bar code scanner is,
etc.) Bar code fonts generally produce very poor quality bar codes.

The best way to add bar codes to an Excel spreadsheet is to use a tool
that generates a high resolution vector style image of a bar code.

TAL Technologies sells a product called B-Coder Professional that is
basically a bar code graphic generator. B-Coder produces very high
resolution Windows metafile images of all bar codes and it also takes
care of adding start/stop codes as well as all the complex details of
generating the correct bar code from a given message being encoded.

B-Coder also has a DDE interface that allows you to automate the
production of bar codes directly from within other programs like
Excel.
For example, you could have a very simple Excel macro that reads down
a column of bar code message data and converts each bar code message
to a bar code image that is inserted directly into the spreadsheet.

If you want very high quality bar codes that are guaranteed to be
readable then B-Coder would be the better way to go.
You can download a demo version of B-Coder Pro at the following web
page:
http://www.taltech.com/products/barcode_software.html

You can also find a very good Excel sample spreadsheet containing a
macro that generates bar codes directly in Excel using B-Coder at the
following URL:

http://www.taltech.com/support/bckb/txt2Barcode.xls





On Wed, 9 Feb 2005 10:01:05 -0800, "Trapper"
wrote:

In setting up an inventory worksheet, it would be very helpful to have
product numbers (SKU) in barcode format for scanning. Is it possible to
create barcodes within Excel?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
create price list from excel sheet -keevill- Excel Discussion (Misc queries) 1 February 8th 05 01:02 AM
how do I create qif files from Excel for import into Quicken? pb Excel Discussion (Misc queries) 2 January 16th 05 01:31 AM
How to I create a pdf file from Word or Excel files stolitx Excel Discussion (Misc queries) 4 December 28th 04 08:17 PM
How do I create a geographic map in Excel 2003? cain Excel Worksheet Functions 1 December 6th 04 11:29 PM


All times are GMT +1. The time now is 09:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"