:: Subscribe to our newsletter
 
Articles / Directory
1/02/2009
Latest version of TraderCode(v2.0) adds new Stock Trading Technical Indicators.



1/02/2009
Launch of NeuralCode(v1.0) for Neural Networks Trading.



8/06/2008
Launch of ConnectCode Excel Training Courses. Get this Free Excel Training (over 100 pages) now.



7/23/2008
ConnectCode Text Manager - add-in that enhances your productivity when working with text in Excel.



6/17/2008
ConnectCode Number Manager - add-in that enhances your productivity when working with numbers in Excel.



6/3/2008
ConnectCode Barcode Font Pack - enables barcodes in office applications and includes an add-in for Excel that supports mass generation of barcodes.



2/1/2008
Release of SparkCode Professional - add-in for creating Dashboards in Excel with sparklines



12/15/2007
Announcing ConnectCode Duplicate Remover - a powerful add-in for finding and removing duplicates entries in Excel



09/08/2007
Launch of TinyGraphs - add in for creating sparklines and tiny charts in Excel.

List of Barcode Formulas

 The Barcode Formulas support parameters for turning on the generation a check digit or human readable , and will automatically convert the data string into a barcode string. The table below provides the entire list of these formulas/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_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.



 

Copyright (c) 2007, ConnectCode Pte Ltd. All Rights Reserved.


Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners