If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to use "barcode" in excel 2000??
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 |
#2
|
|||
|
|||
how to use "barcode" in excel 2000??
It depends on how you intend printing the labels. If you're wanting a
simple all in one solution, 'Bizfonts' (http://www.bizfonts.com/) can help. Another way is to use a 'bar code module' (http://www.image-cs.co.uk/products/bcmodules.htm) and write your own code. This is relatively easy. you create a text file from excel using open# and print# and pass the barcode data to the file. I have already wrote the Vba code to do this and can post if you decide to purchase a BCM. --- Message posted from http://www.ExcelForum.com/ |
#3
|
|||
|
|||
how to use "barcode" in excel 2000??
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 "gg" gg@mashimalucom wrote in message ... 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 |
#4
|
|||
|
|||
how to use "barcode" in excel 2000??
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/ On Sun, 20 Jun 2004 21:17:47 -0700, "gg" gg@mashimalucom wrote: 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 |
Thread Tools | |
Display Modes | |
|
|