Generating a barcode from cell data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a macro or some such app that will automatically create a 3 of 9
barcode in a worksheet from data in a particular cell. When data in the cell
is changed, the barcode changes automatically.

Does anyone know of any free code on the web that will accomplish this?

If not free, any suggestions of purchase code?

Thanks!
 
Think you just need a font that displays the 3 of 9 barcode. From a
previous post by David McRitchie:

If you are printing 3of9 barcodes it should simply be a matter of font.
More information in
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
and the ultimate barcode reference
http://www.barcode-1.net/


------------------

Most of David's first cited page is on mailmerge, but if you go down to
about the last 9/10 ths of the page, you will find

Bar Code information (#barcode)

with extensive information and links.
 
Thanks for the suggestion.

However...is there any way to 'embed' the font so that the file opened on
another machine will see the barcode? I need to be able to email the file to
other users and they be able to see and print the barcodes.
 
Unlike Word, you can't attach or embed a font in a workbook.
You'd have to sent the font to the users and have them install it
on their machines.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Except, as I've mentioned above, I need to be able to send the workbook to
another user and they be able to open the file and see the barcode. So, fonts
really don't work.

Any thoughts on free or purchased macros?
 
Clapper,

You can do this using our BarCodeWiz Barcode ActiveX Control.
You simply select one or more cells and click on "Selection To
Barcodes" on the toolbar to create barcodes. The barcodes are inserted
into the spreadsheet as images and you can distribute the files to
other users. Please see this page for a quick overview:

http://www.barcodewiz.com/msLanding.asp

If you have any questions, don't hesitate to ask.

Alek Szymanski
http://www.barcodewiz.com
 
Back
Top