Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default barcode printing

Thomas Lutz wrote in message . ..
Bar Code fonts can be extremely difficult to use because you cannot
simply select the text that you want to encode and change the font to
a bar code font. You also need to include special start and stop codes
and with some types of bar codes, you also need to calculate a check
digit value from all the characters in the bar code data and append
the check digit to the data.
It gets very tricky and in addition, bar code fonts generally produce
very poor quality bar codes that print differently on different
printers and therefore can be difficult to read.

A better approach would be to use a bar code ActiveX control like the
one from TAL Technologies. The TAL bar code ActiveX control is
extremely easy to use. You just drop it onto your spreadsheet and set
a few properties in the control's properties window. The control also
supports a "Linked Cell" property so you can bind it to a cell so that
when you change the data in a cell, the bar code is automatically
generated using the data in the cell as the data to be encoded in the
bar code.

For more information or to download a demo version please visit:
http://www.taltech.com/products/activex_barcodes.html

The demo version of the control is fully functional and it also comes
with a sample Excel spreadsheet that demonstrates how to use it in
Excel.

On Sun, 7 Mar 2004 16:40:32 -0600, eyecalibrate
wrote:

I have a value in column "A". I want to turn this into a barcode in
column "B" so that I can print it out. How do I (or can I) accomplish
this conversion?

Thanks,

David


---
Message posted from http://www.ExcelForum.com/


A barcode font is sufficient - no programming needed and quality is
ensured. Take a look at www.morovia.com/font/support. Several samples
can be found there.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 691
Default barcode printing

This is a rather old thread, free fonts are available,
so there is no need to purchase a barcode font:
http://google.com/groups?threadm=e91...GP12.phx.g bl

There are over 300 barcodes, some do require programming,
(or a program), but you can create barcodes with just a font.

look for topic:
Can Word, Access, Excel, or Clipper be used for an application
where bar codes can be scanned and printed?
http://www.barcode-1.net/pub/russadam/faq.html
also note as stated free fonts are available and that the
easiest True Type barcode font to use is Code 39.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"MontereySoft" wrote in message
A barcode font is sufficient - no programming needed and quality is
ensured. Take a look at www.morovia.com/font/support. Several samples
can be found there.



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
barcode in excel Nik Excel Discussion (Misc queries) 2 November 18th 09 03:02 PM
Scanning a barcode BAKERSMAN Excel Discussion (Misc queries) 2 July 24th 07 06:32 PM
barcode macro Joe OE Excel Worksheet Functions 1 December 11th 06 09:42 PM
Barcode 128 B Add-In Safi Excel Worksheet Functions 0 August 16th 06 07:56 AM
barcode b.law Excel Discussion (Misc queries) 3 December 20th 04 11:24 PM


All times are GMT +1. The time now is 10:36 AM.

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"