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 Name | Parameters | Description |
| 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. |