how to use "barcode" in excel 2000??

[gg]

Dear all,

i would like to set up an inventory system for recording
the stuff. previously, i have a long table of data in
excel. i need to do some tasks:
1)print the barcode out for each item
2)scan the barcode for checking the inventory.

i have no idea how to start, install barcode fonts? what i
have to buy and do i need to write "MARCOS"?

Please help me!
manymany thanks.

gg

 

[opeel]

It depends on how you intend printing the labels. If you're wanting
simple all in one solution, 'Bizfonts' (http://www.bizfonts.com/) ca
help. Another way is to use a 'bar code module
(http://www.image-cs.co.uk/products/bcmodules.htm) and write your ow
code. This is relatively easy. you create a text file from excel usin
open# and print# and pass the barcode data to the file. I have alread
wrote the Vba code to do this and can post if you decide to purchase
BCM

 

[Alek Szymanski]

Hello,

If you have a minute, please take a look at BarCodeWiz ActiveX
Component:

http://www.barcodewiz.com

The ActiveX is a small plug-in, which can be used very effectively in
Excel. The demo (you can download it for free) comes with an Excel
file, which includes a macro you can use. It works like this:

1. Select a range of cells with the data you'd like changed into a
barcode.
2. Run the macro.
3. Every cell you'd selected is replaced with an image of a bar code
representing your encoded data.

If you'd like to download the demo, here is the link to the demo page:
http://www.barcodewiz.com/demo.asp


Please contact me with any questions you might have.

Alek Szymanski
Add barcodes to your programs and documents
http://www.barcodewiz.com

 

[Thomas Lutz]

It is possible to print bar codes in Excel however it requires using a
good tool like a bar code ActiveX control to do the job. ActiveX
controls are software components that you can drop directly onto an
Excel spreadsheet. Depending on how complex your requirements are, you
may need to write a small amount of VBA code (macros) in Excel to get
everything working the way that you want.
Regarding the bar code input, you will almost certainly need to do a
small amount of programming to implement an inventory application in
Excel. Bar code scanners work like a second keyboard on your PC. When
you scan a bar code, the data would go into Excel as if it were being
typed in on the keyboard. This means that you would need to be able to
process the data from the bar code scanner somehow. In an inventory
application you typically have to do a lookup on the data that you
receive from the scanner and find the right data in the spreadsheet
that contains the bar code number that you scanned.
For most inventory applications you would typically want to use a
database applciation like Microsoft Access. Access has much better
handling of lookup type functions as well as reporting and label
printing.

For an excellent bar code ActiveX control that works extremely well in
both Excel and Access, visit
http://www.taltech.com/products/activex_barcodes.html

There is a demo on the above page that you can download and the demo
comes complete with a sample Access database and an Excel spreadsheet
that demonstrates how to use the bar code ActiveX control to print bar
codes in both these programs.

The above site is also a very good place to learn about bar code
technology in general. I would recommend that you look at the bar code
tutorial in the following link:
http://www.taltech.com/resources/intro_to_bc/