Barcode & Labels for Office
provides a collection of tools for creating barcodes in Office
Barcode objects may be inserted into documents, and tools are provided for converting a selected item (text in Word, one or more cells in Excel or Access) into high quality barcode pictures or font based barcodes. Active-X controls are also included for use on documents, spreadsheets, forms or reports. The samples provided are suitable for use in Office 2007 or later, including Office 2016 (32 and 64 bit versions). The product also includes an in-cell formula module for Excel, allowing font-based barcode to be created using an in-cell formula. The source code for a number of barcode macros is included to allow for easy customisation.
The product also allows labels/pages to be printed, including using data taken from Excel or Access. Labels can contain text, barcode, table, shape, line and picture elements. Text may be centred, or left or right aligned and may be rotated through any angle. Suitable for allergen labelling (see Food labelling)
Word Labels from Excel
Screen shots - click to enlarge
See more images
1D versions of Barcode & Labels for Office supports: 2 of 5, 3 of 9, Australia Post, Codabar, Code 11, Code 39, Extended Code 39, Code 93, Extended Code 93, Code 128, Code B, Deutschen Post, DUN14, EAN- 8, EAN-13, EAN-14, GS1/EAN/UCC-128, Infomail, Intelligent Mail (OneCode), Intelligent Mail Package Barcode, ISBN, ISMN, ISSN, ITF-14, ITF-6, Interleaved 2 of 5, Italian Post 2/5, Italian Post 3/9, JAN, Korean Postal Authority, Matrix 2 of 5, MSI (Modified Plessey), Plessey, PostNet, Planet & FIM, Royal Mail 4 State, SSCC, SICI/SISAC, Swiss Post, Telepen (numeric and ASCII), UCC14, UPC-A, UPC-E. See product's Help file for details of types supported.
2D versions support Aztec, Datamatrix (including DMRE), MailMark, PDF417, Micro PDF417, QR Code and Micro QR Code as font barcodes and several additional types as picture barcodes. See product's Help file for details of types supported.
Available as a single computer product or as a multi-user version for installation on up to 10 PCs.
The following licence types are available:
Barcodes & Labels for Office - Full version (supports 1D & 2D
Barcodes & Labels for Office - 1D version (supports only 1D barcodes)
Barcodes & Labels for Office - 2D version (supports only 2D barcodes)
Note: Barcode & Labels for Office is an end-user product. Developers requiring similar functionality for redistribution should use the dBarcode Developer kits and or Labels.Net
Requires Microsoft Windows XP/Vista/Windows 7/8/10*, and one or more of the following components of Microsoft Office: Word (2007-2016), Excel (2007-2016), Access (2007-2016). Includes samples for Office 2007/2016 and the 64 bit Office 2010-2016 (with VBA7).
*Barcodes and Labels for Office is supported by dLSoft on the following editions of Windows 10 – Home, Pro, Education and Enterprise. Barcodes and Labels for Office is supported on the in-market supported servicing branches of Windows 10 including - Current Branch, Current Branch for Business and the following Long-Term Servicing branch - Windows 10 Enterprise LSTB 2016.
Creating barcodes in Word may be accomplished by using Active controls or barcode macros. Macros included within Barcodes& Labels for Office provide the facility to create ont or picture barcodes from selected text.
In Word the PBarcode macros replace the selected text with a barcode Picture; the FBarcode macros replace the selected text with a font-based barcode.
For details and examples see Generating barcodes in Word
Font or picture barcodes can be included on Excel spreadsheets by
using Active controls, barcode macros, or in-cell formulae.
For details and examples see Generating barcodes in Excel
In Excel's sheet view the PBarcode macros take the code(s) from one or more selected cells and position the barcode image(s) over the adjacent cell, adjusting the row height to accommodate the image. The FBarcode macros insert the font-based barcode text into the adjacent cell and set the selected barcode font. (Of course the macros can be edited to change the destination). The control may be placed on a spreadsheet and its data source linked to a specified cell. The source code for the macros is included in the distribution.
Picture barcodes can be included on Access forms or reports by using Active controls or barcode macros. Macros also provide the facility to create and store font or picture barcodes within the database.
In Access's datasheet view the PBarcode macros take the code(s) from one or more selected records' BarcodeSource field and paste each barcode image as a picture into the Barcode field. The FBarcode macros take data from one or more selected records BarcodeSource field and place the font-based barcode into the Barcode field. This Barcode field may act as the source for a picture or text control on a form or report. The Active-X control may be placed on a form or report and its data taken from a table or query.
For details andl examples see Generating barcodes in Access
This product is suitable for use with Word's Mail-merge when font-based barcodes are used.
The dLSoft Barcode & Labels for Office PBarcode macros creates images that are stored within the document, spreadsheet or table. For large spreadsheets or databases this can result in very large file sizes, and in such cases the FBarcode macros or the Active-X control are recommended.