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!

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

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" <clapper@discussions.microsoft.com> wrote in message
news:953F03AD-522D-48C7-9C88-5CEC51E7CCD7@microsoft.com...
> 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!

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
>

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" <clapper@discussions.microsoft.com> wrote in message
news:CE034422-170D-4596-A70B-B484C06800E5@microsoft.com...
> 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
>>

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" <clapper@discussions.microsoft.com> wrote in message
> news:953F03AD-522D-48C7-9C88-5CEC51E7CCD7@microsoft.com...
> > 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!
>
>
>

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?
>
>

Link on the page link I provided:

http://www.designworkz.com/barcode.htm

--
Regards,
Tom Ogilvy

"clapper" <clapper@discussions.microsoft.com> wrote in message
news:2D4C652C-8A9D-42FE-AE0E-43F3A10E4B36@microsoft.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?
>
>
>
> "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" <clapper@discussions.microsoft.com> wrote in message
> > news:953F03AD-522D-48C7-9C88-5CEC51E7CCD7@microsoft.com...
> > > 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!
> >
> >
> >