Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating a barcode from cell data
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating a barcode from cell data
The best way of doing this is to use the 3 of 9 barcode font!
http://www.barcodesinc.com/free-barcode-font/ that is the download page -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200605/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating a barcode from cell data
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/ --- 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 ------------------ 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. -- Regards, Tom Ogilvy "clapper" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating a barcode from cell data
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. "Crowbar via OfficeKB.com" wrote: The best way of doing this is to use the 3 of 9 barcode font! http://www.barcodesinc.com/free-barcode-font/ that is the download page -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200605/1 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating a barcode from cell data
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 "clapper" wrote in message ... 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. "Crowbar via OfficeKB.com" wrote: The best way of doing this is to use the 3 of 9 barcode font! http://www.barcodesinc.com/free-barcode-font/ that is the download page -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200605/1 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating a barcode from cell data
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? "Tom Ogilvy" wrote: 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/ --- 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 ------------------ 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. -- Regards, Tom Ogilvy "clapper" wrote in message ... 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! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating a barcode from cell data
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 clapper wrote: 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? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating a barcode from cell data
Link on the page link I provided:
http://www.designworkz.com/barcode.htm -- Regards, Tom Ogilvy "clapper" wrote in message ... 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? "Tom Ogilvy" wrote: 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/ --- 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 ------------------ 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. -- Regards, Tom Ogilvy "clapper" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert data into barcode | Excel Discussion (Misc queries) | |||
link barcode to cell | Excel Discussion (Misc queries) | |||
What Barcode generating software is recomended. | Excel Discussion (Misc queries) | |||
Convert My Data into Barcode 128 B | Excel Worksheet Functions | |||
UDF for Data into 128 B barcode problem | Excel Worksheet Functions |