List of Barcode Macros and Functions

All the functions available in the Encoder like generating a check digit, formatting the encoded barcode string and adding of start/stop characters are also made available as Microsoft Office Macros and VB Functions. The table below provides the entire list of macros/functions. All these functions can be used in Excel, Word, Access and Crystal Reports.

Function Name Parameters Description
Encode_Code39 Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Generate a Check Digit, 0 for otherwise
Returns the encoded barcode string for Code 39 barcode. Invalid characters from the input will be automatically removed.
Encode_Code39ASCII Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Generate a Check Digit, 0 for otherwise
Returns the encoded barcode string for Code 39 ASCII barcode. Invalid characters from the input will be automatically removed.
Encode_Code93 Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Generate a Check Digit, 0 for otherwise
Returns the encoded barcode string for Code 93 barcode. Invalid characters from the input will be automatically removed.
Encode_EAN8 Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for EAN 8 barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_EAN13 Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Encode with Human Readable Text, 0 Otherwise
Returns the encoded barcode string for EAN 13 barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_EXT2 Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for UPC Extension 2 barcode. Invalid characters from the input will be automatically removed.
Encode_EXT5 Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for UPC Extension 5 barcode. Invalid characters from the input will be automatically removed.
Encode_UPCA Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Encode with Human Readable Text, 0 Otherwise
Returns the encoded barcode string for UPCA barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_UPCE Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Encode with Human Readable Text, 0 Otherwise
Returns the encoded barcode string for UPCE barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_UCCEAN Param 1 - String value to be encoded as a barcode

Sample Input - (00)123456789012345675
(12)1A
Returns the encoded barcode string for UCCEAN barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_Code128Auto Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for Code128 Auto barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_Code128A Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for Code128A barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_Code128B Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for Code128B barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_Code128C Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for Code128C barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_I2of5 Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Generate a Check Digit, 0 for otherwise
Returns the encoded barcode string for I2of5 (Interleaved 2 of 5) barcode. Invalid characters from the input will be automatically removed.
Encode_ITF14 Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Generate a Check Digit, 0 for otherwise
Param 3 - Integer value 0 to generate Top/Bottom Bearers Bar and 1 to generate Rectangle Bearers Bar.
Returns the encoded barcode string for ITF14 barcode. Invalid characters from the input will be automatically removed.
Encode_Industrial2of5 Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Generate a Check Digit, 0 for otherwise
Returns the encoded barcode string for Industrial 2of5 barcode. Invalid characters from the input will be automatically removed.
Encode_ModifiedPlessy Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Generate a Check Digit, 0 for otherwise
Returns the encoded barcode string for Modified Plessy barcode. Invalid characters from the input will be automatically removed.
Encode_CodeCodabar Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for Codabar barcode. Invalid characters from the input will be automatically removed.
Encode_POSTNET Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for POSTNET barcode. Invalid characters from the input will be automatically removed.
Encode_GS1Databar14 Param 1 - String value to be encoded as a barcode
Param 2 - optional linkage field, default value is 0
Returns the encoded barcode string for the GS1 DataBar 14 barcode. Invalid characters from the input will be automatically removed. The font name to be used for this barcode is CCodeGS1D_Sx.
Encode_GS1Databar
Limited
Param 1 - String value to be encoded as a barcode
Param 2 - optional linkage field, default value is 0
Returns the encoded barcode string for the GS1 DataBar Limited barcode. Invalid characters from the input will be automatically removed. The font name to be used for this barcode is CCodeGS1D_Sx.
Encode_GS1Databar
Expanded
Param 1 - String value to be encoded as a barcode
Param 2 - optional linkage field, default value is 0
Returns the encoded barcode string for the GS1 DataBar Expanded barcode. Invalid characters from the input will be automatically removed. The font name to be used for this barcode is CCodeGS1D_Sx.
Encode_GS1Databar
Truncated
Param 1 - String value to be encoded as a barcode
Param 2 - optional linkage field, default value is 0
Returns the encoded barcode string for the GS1 DataBar Truncated barcode. Invalid characters from the input will be automatically removed. The font name to be used for this barcode is CCodeGS1DTR
_S3.
     
Helper Function NameParametersDescription
SSCC Param 1 - String value to be encoded as a Serial Shipping Container Code (SSCC)
The SSCC function performs padding and automatically adds a MOD 10 check digit to the input data. The output is a valid Serial Shipping Container Code.
GTIN Param 1 - String value to be encoded as a Global Trade Item Number (GTIN)
The GTIN function performs padding and automatically adds a MOD 10 check digit to the input data. The output is a valid Global Trade Item Number.
MOD_10 Param 1 - String value to be used for calculating the MOD 10 check digit
The MOD_10 function calculates and returns a MOD 10 check digit based on the input data.