Is there a way to put "scanable" UPC Codes into an Excel Spreadsheet

[Jon]

I work for a major retailer and one wway I have found to
increase job performance is to be able to create excel
reports. I currently cut and paste my bar codes onto the
report for me employees, but I was told there is a way
to "Add On" the option right into Excel.

How do I go about doing that?

Thank you.

 

[jr]

Am I incorrect in understanding that you literally "cut
and paste" the barcodes and not in the computer sense?
If so, there may be other ways but your scan generating
software probably has an export feature that allows you
to export to the clipboard and then paste into a report.
Bartend is one that I know of.

 

[jr]

Bartend (SEAGULL SCIENTIFIC) is a program (possibly not
the best. Just happens to be the one that we got) that
generates barcodes from numbers that are input. I'm sure
it has other functions but I haven't bothered to learn
more beyond that.
Yes, it wouldn't surprise me to find out that someone
created a barcode handling add-in. I'm sure somewhere
someone has devised an EXCEL addin that changes water
into wine.

 

[Aaron Queenan]

I work for a major retailer and one wway I have found to
increase job performance is to be able to create excel
reports. I currently cut and paste my bar codes onto the
report for me employees, but I was told there is a way
to "Add On" the option right into Excel.

How do I go about doing that?

Search the internet for:

barcode font

Just add the start and stop characters, and if necessary the checksum, using
a formula or VBA, and then change the cell font to the barcode font.

http://www.free-barcode-font.com/
http://www.adams1.com/pub/russadam/fonts.html
http://www.idautomation.com/
http://www.bizfonts.com/
http://www.hallogram.com/barcodes/software/#dev

Regards,
Aaron Queenan.

 

[jaf]

Hi Jon,
In Excel a barcode is displayed by using a barcode font.
If the barcode you want isn't on your system there are hundreds of place on
the web to download them.

The only thing you may have to do is add a carriage return so the scanner
sees the end of line.
So the formula in the cell would look like...
=123456 & char(13)

 

[Thomas Lutz]

You might look at a product called B-Coder from TAL Technologies. It
is a program that generates high resolution images of bar codes that
you can insert into Excel spreadsheets, Word documents and other
applications.
You could also use a bar code ActiveX control direclty in your
spreadsheet. TALtech also has an excellent bar code ActiveX control.
You can get more information about both products as well as download
demos from the following URLs:
http://www.taltech.com/TALtech_web/products/barcode_software.html

http://www.taltech.com/TALtech_web/products/activex_barcodes.html

Both products produce extremely high quality bar codes that will read
perfectly every time.