i have a problem of Excel, i want to generate Bar Code by the excel
worksheet ,
has any suggestion give to me to generate bar code by the excel in a
worksheet ?and those bar code can be recongnise by scanner.

"king kwong" <king wrote :
i have a problem of Excel, i want to generate Bar Code by the excel
worksheet ,
has any suggestion give to me to generate bar code by the excel in a
worksheet ?and those bar code can be recongnise by scanner.

You may download bar code fonts and define the correct "set" for each bar
position etc. in VBA...

The easiest way, however, is to buy a commercial module.
There are freebies but I like to use TBarCode by TEC-IT - it costs a bit, but it
is easy to use and works fine.
I use it when creating documents with Word, CorelDraw and other software, too.

Matti P., Finland

The easiest way is to use a barcode font. Check the web for one that
supports your required format.
There are many free examples around.

Whether these can be read by your scanner will depend somewhat on the size
they are printed, your printer and the scanner. Do some testing.

NickHK
Personally I prefer making the barcode from a set drawn lines which I've
started in VB6. It has the advantage of being more flexible, as you can make
bmp or emf files, or indeed send directly to the printer. You do however
need to understand the logic behind your format(s), which are generally not
too difficult. e.g. EAN13
http://www.barcodeisland.com/ean13.phtml

"king kwong" <king wrote in message
...
i have a problem of Excel, i want to generate Bar Code by the excel
worksheet ,
has any suggestion give to me to generate bar code by the excel in a
worksheet ?and those bar code can be recongnise by scanner.

The easist way is to use a barcode font. If you have no preference on
the barcode format, use code 39:

http://www.morovia.com/font/code39.asp

The easiest and best way to pint bar codes from Excel is to use a good
quality bar code ActiveX control like the TAL Bar Code ActiveX control
http://www.taltech.com/products/activex_barcodes.html

A bar code ActiveX control will do all the calculations for you and
produce a good quality image of a bar code. All you need to do is drop
the control on the spreadsheet from the "Controls Toolbox" and set a
few properties of the control. When you print your sheet, the bar
codes will print. If you use a good quality ActiveX control like the
one from TAL, a vector graphic image will be produced that will print
perfectly on any printer.

Beware of ActiveX controls that use bar code fonts or generate bitmap
images. The generally produce poor quality bar codes that will be
difficult to read.


On Sun, 3 Jun 2007 22:45:00 -0700, king kwong <king
wrote:

i have a problem of Excel, i want to generate Bar Code by the excel
worksheet ,
has any suggestion give to me to generate bar code by the excel in a
worksheet ?and those bar code can be recongnise by scanner.