Creating Code 128 barcodes in Microsoft® Office has never been easier.
With BarCodeWiz Toolbar you can add barcodes to Microsoft® Office applications with a click of a button. In Microsoft® Word, create single barcodes, pages of labels, or mail merge documents. In Microsoft® Excel®, select one or more cells and convert to Code 128 barcodes. In Microsoft® Access®use
the included functions to create reports with barcodes based on your data tables.
BarCodeWiz Code 128 Barcode Fonts and the included
toolbars are compatible with
every version of Microsoft® Office
from 97 to 2013 (32 and 64-bit) and Windows 98 through Windows 8.
|
Code 128 Barcodes in Microsoft Excel
|
|
|
|
To create Code 128 barcodes in Excel, simply select one or more cells and click on Selection To Barcodes on BarCodeWiz toolbar.
|

|
|
Your data is converted to Code 128 barcodes. Start, stop, and the check digit
characters are automatically calculated and added as necessary. The correct
subset of Code 128 is also determined for each cell. |

|
|
Would you like the barcode to update whenever one of your cells changes?
Here's how:
In this example, we use the formula =BCW_Code128c(A1) in cell
B1. This means that the data from A1 is encoded as Code 128 C in cell
B1. Change the cell font to CW_Code128C_1 and the barcode is ready.
Any changes in column A will be automatically reflected in column
B
|

|
A simple way to create sequential barcodes is to use Sequential Number Generator. |
 |
Code 128 Barcodes in Microsoft Word
|
|
|
|
|
Creating a barcode in Microsoft Word is as simple as selecting the text you wish to encode...
|
|
|
...and clicking on Selection To Barcode on your toolbar.
|
|
|
In order to create multiple barcodes, enclose each piece of text within
square brackets - [ ] - as shown here...
|
|
|
...and click on Convert All to create the barcodes. This method is also useful when creating labels and mail merge documents.
|
|
Print pages of barcode labels using the Mail Merge wizard. Surround the
barcode fields with square brackets, as below.
 |
|
|
Code 128 Fonts in Microsoft Access
|
|
|
|
Step 1. Import the FontFunctions
module to your database:
- Click on External Data tab > Access
- In the new window Browse for the file barcodewiz.mdb and
click OK. The default location
is:
C:\Program Files (x86)\BarCodeWiz UPC
EAN Fonts\barcodewiz.mdb
- Select FontFunctions from the Modules tab and click OK.
|
Step 2. Insert a Text Box into
your report and adjust its properties. The example below had the following
properties changed:
- Control Source: =BCW_Code128B([PartNumber]) (PartNumber is the table
field containing barcodes)
- Font Name: BCW_Code128B_2
- Font Size: 18
- Fore Color: #000000 (black, recommended for better print
quality)
Step 3. Preview the generated report
|
|
|
 |
|
|
|
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. |
We develop mobile scanning applications for tracking mail and baggage. In order to test these applications we need to generate thousands of barcodes quickly and print them on plain paper. Your MS Excel Add-in solved that problem for us.Neil Moore
Continental Airlines Technology
After evaluation of half a dozen or so applications, we decided to use Barcodewiz, mainly because of its simple integration to MS Office. We would have no hesitation in recommending this software. John S Smith
ICT Manager
DAMS Furniture Ltd