|
![space](/barcode-image/spacer.gif) |
![interleaved 25 barcode interleaved 25 barcode](/barcode-image/i25box.gif) |
![space](/barcode-image/spacer.gif) |
Price: US$89
|
![space](/barcode-image/spacer.gif) |
Compatible with Excel versions 2003 and later
|
|
|
Interleaved 2 of 5 barcode is designed to encode numeric data. Interleaved 2of5 barcode has a high data density than standard 2of5.
With Barcodesoft Interleaved 2 of 5 barcode font package and Microsoft® Office, it is very convenient to print Interleaved 2 of 5 bar code from your desktop printer.
1. Copy all true type fonts (*.ttf) under fonts folder to your c:\Windows\Fonts folder.
2. Open DOS prompt. If you are using Windows Vista or Windows 7, please Open DOS prompt as administrator.
Please go to the following folder
CD C:\Program Files (x86)\Common Files\Barcodesoft\FontUtil
Type in the following DOS command to register crUFLbcs.dll
regsvr32 crUFLbcs.dll
![interleaved 2of5 barcode interleaved 2of5 barcode](/barcode-image/dosreg.png)
If registration fails, please use the following DOS command to register it.
Regtlibv12 is a utility of Windows .NET Framework 2.0.
Regtlibv12 _cruflbcs.tlb
3. Start Microsoft® Excel® first.
If you are using Excel 2000 or 2003, click menu ===> Tools ==> Macro ===> Security.
Choose Low security level.
![interleaved 2of5 barcode interleaved 2of5 barcode](/barcode-image/macro-security.jpg)
If you are using Excel 2007, click the Microsoft Office Button ![interleaved 2of5 barcode office interleaved 2of5 barcode office](/barcode-image/msoffice.gif)
Then click Excel Options, choose Trust Center. In the Macro Settings category, under Macro Settings,
choose "Enable all macros" as shown below.
![interleaved 2of5 barcode setting interleaved 2of5 barcode setting](/barcode-image/macrosetting.png)
4. Press ALT + F11 to open Microsoft® Visual Basic editor.
![interleaved 2of5 barcode interleaved 2of5 barcode](/barcode-image/vba.jpg)
5. From Visual Basic editor, choose menu Tools ===> References. It will popup a dialog. Click Browse button and choose cruflbcs.dll from your working folder.
Usually it's under C:\Program File\CommonFiles\Barcodesoft\Fontutil folder.
Click the checkbox beside crUFLBcs 1.0 Type Library as shown below. Then click OK button.
![interleaved 2of5 bar code interleaved 2of5 bar code](/barcode-image/barcode-addref.png)
6. Press Ctrl+M in Visual Basic editor, it will popup a dialog, choose barcodesoft.bas under
C:\Program File\CommonFiles\Barcodesoft\Fontutil folder. Then click "Open".
If you don't find barcodesoft.bas, please download it from Barcode Software
![interleaved 2of5 barcode vba interleaved 2of5 barcode vba](/barcode-image/importvba.jpg)
7. Close Visual Basic and go back to your spreadsheet. Now, you can use one of the following macros to encode data: ITF25, ITF25Check, MasterCartonCode. When you have lots of data to process, you can just copy and paste the macro to the whole column of data.
=itf25(xxx)
=itf25check(xxx)
=mastercartoncode(xxx)
Please use cell reference to replace xxx in the formulas as shown below.
![interleaved 2of5 barcode macro interleaved 2of5 barcode macro](/barcode-image/macroi25.jpg)
8. Right click Cell B1, choose Format Cell from context menu. Then click Font to apply one of the appropriate font typefaces to the cell.
![interleaved 2of5 barcode font interleaved 2of5 barcode font](/barcode-image/typefacei25.jpg)
Another smart and simple solution for printing Interleaved 25 barcode is using Microsoft® Word. First launch Barcodesoft Encoder, then type in whatever you would like to encode. Then press the Copy to clipboard button. Now open Word, and press Ctrl+V. You will see interleaved 2of5 bar code or master carton code appear.
For more information about Interleaved 2 of 5 barcode, please click BarCodeSoft Interleaved 25.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
|
|
|