:: Subscribe to our newsletter
 
Articles / Directory
02/10/2012
Latest version of TraderCode(v5.5) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.



1/04/2011
InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.



9/01/2009
Launch of
Free Investment and Financial Calculator for Excel.



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.

Using Barcode Formulas in Excel



It is extremely easy to create and print barcodes in Excel. Functions like generating a check digit, formatting the barcode string and adding of start/stop characters are also supported in Microsoft Office Macros. Before you begin, please make sure that ConnectCode has been installed on your computer.

Adjusting Security Settings in Excel
  1. Start Microsoft Excel
  2. Click on the menu Tools->Macro->Security...
  3. Set the security to Medium
The above steps only need to be carried out once in Excel



          

          

Import the VBA macros / formulas into Excel
  1. Launch Microsoft Excel
  2. Click on the menu Tools->Macro->Visual Basic Editor.




  3. Click on the menu File->Import File...




  4. Select the Encoder.bas file that is bundled with ConnectCode. This file is located in the Resource sub directory where ConnectCode is installed




  5. Click on Save followed by Close in the Visual Basic Editor


Creating a barcode in Excel
  1. Launch Microsoft Excel
  2. Create a new Excel Spreadsheet.
  3. Key in the data "1234" in the cell A1 as shown below. Leave the next column for the barcode.





  4. Enter the macro function in cell B1. For example, to encode a Code 39 barcode, set this cell to "=Encode_Code39(A1)".
  5. Hit the Enter key to see the encoded barcode string "*1234A*"
  6. Change the font in the cell containing the encoded barcode string (cell B1) to CCode39_S3. You can also choose a different font size to adjust the height.
  7. You can enter more data in the first column. After which you can encode them as barcode by copying and pasting the encoding function in the second column.






To encode other type of barcodes like Code 128 or UPC/EAN barcode or I2of5, simply use the appropriate functions/macros/formulas listed in the section List of Barcode Formulas


 

Copyright (c) 2007-2014, 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