VBA Functions for Standard Barcode Fonts | |||
Barcode Type | Barcode Function Methods | Notes | VBA File to Import | Required Font |
Code-11 | Code11 (DataToEncode) | IDAutomationVBA.bas | IDAutomationC11 |
Code-128 (Auto Mode) | Code128 (DataToEncode, C128 ReturnType, ApplyTilde) Human Readable text is enabled when ReturnType = 6 Example: Code128('123456789012', 6, 0) | IDAutomationVBA.bas or IDAutomation VBA for Code 128 and Postnet.bas* | IDAutomationC128 |
Code-128 (Manual Mode) | IDAutomation recommends using Auto Mode for most situations. Code128a (DataToEncode, C128 ReturnType) Code128b (DataToEncode, C128 ReturnType) Code128c (DataToEncode, C128 ReturnType) Example: Code128b('12345678', 6) | IDAutomationVBA.bas or IDAutomation VBA for Code 128 and Postnet.bas* | IDAutomationC128 |
Code-39 | Code39 (DataToEncode) Code39Mod43 (DataToEncode, ReturnType) Example: Code39Mod43('12345678', 0) | IDAutomationVBA.bas | IDAutomationC39 |
Code-93 | Code93 (DataToEncode) | IDAutomationVBA.bas | IDAutomationC93 |
Codabar | Codabar (DataToEncode) | IDAutomationVBA.bas | IDAutomationCB |
EAN-13 | IDAEAN13 (DataToEncode) | IDAutomationVBA.bas | IDAutomationUPCEAN |
EAN-8 | IDAEAN8 (DataToEncode) | IDAutomationVBA.bas | IDAutomationUPCEAN |
GS1-128 | Code128 (DataToEncode, C128 ReturnType, 1) GS1-128 is enabled in Code 128 Auto by setting ApplyTilde to True. Human Readable AIs may be created by setting the C128 ReturnType to 6. Example: Code128('(12)3456789012', 6, 1) | IDAutomationVBA.bas or IDAutomation VBA for Code 128 and Postnet.bas* | IDAutomationC128 |
Interleaved 2 of 5 | I2of5 (DataToEncode) I2of5Mod10 (DataToEncode, ReturnType) Example: I2of5Mod10('123456789', 1) NOTE: ReturnType 3 generates an OPC (Optical Product Code) symbol. OPC is also known as Vision Council of America OPC, VCA BarCode & VCA OPC.Example: I2of5Mod10('020748721', 3) | IDAutomationVBA.bas | IDAutomationI25 |
MSI / Plessey | MSI (DataToEncode, ReturnType) | IDAutomationVBA.bas | IDAutomationMSI |
RM4SCC | RM4SCC (DataToEncode) | IDAutomationVBA.bas | IDAutomationRM |
UPC-A | UPCa (DataToEncode) | IDAutomationVBA.bas | IDAutomationUPCEAN |
UPC-E | UPCe (DataToEncode) | IDAutomationVBA.bas | IDAutomationUPCEAN |
USPS IntelligentMail (IMb) | IntelligentMail (DataToEncode) ** Included only in the purchased version of the USPS IMb Font Package. | IDAutomation VBA for Intelligent Mail.bas | IDAutomationPOSTNET or IDAutomationIMB |
USPS Postnet | Postnet (DataToEncode, ReturnType) *Included in Postnet package. | IDAutomationVBA.bas or IDAutomation VBA for Code 128 and Postnet.bas* | IDAutomationPOSTNET |
USPS Planet | Planet (DataToEncode, ReturnType) | IDAutomationVBA.bas or IDAutomation VBA for Code 128 and Postnet.bas* | IDAutomationPOSTNET |
not applicable | MOD10 (DataToEncode) | IDAutomationVBA.bas | not applicable |
not applicable | SpliceText (DataToEncode, SpacingNumber, ApplyTilde) | IDAutomationVBA.bas | not applicable |
Functions for the Universal Barcode Font | |||
All functions listed below are preceded with IDAutomation_Uni_.* They may only be used with the IDAutomation Universal Barcode Font Advantage™ and are supplied in the IDAutomation_UniversalFont_VBA.bas or the IDAutomationWindowsDLLVBA.bas file which also requires the installation of the product EXE file in order for the macro to function, because they access an installed IDAutomationNativeFontEncoder.dll that is provided within the package. Note: Excel 2004 for Mac requires the functions to be lowercase. Ex: idautomation_uni_c128 | |||
Barcode Type | Universal Function Methods | Notes | VBA File to Import | Required Font |
Code-128 | IDAutomation_Uni_C128 (DataToEncode, ApplyTilde) Note: Code128() is the recommended method to use. Code128() is also used to create GS1-128. IDAutomation_Uni_C128A (DataToEncode) IDAutomation_Uni_C128B (DataToEncode) IDAutomation_Uni_C128C (DataToEncode) Example: IDAutomation_Uni_C128 ('Ê8100712345Ê2112WH5678', TRUE) Excel for Mac: idautomation_uni_c128 ('Ê8100712345Ê2112WH5678', TRUE) | IDAutomation_UniversalFont_VBA.bas or IDautomation_WindowsDLLVBA.bas and IDAutomationNativeFontEncoder.dll | IDAutomation_Uni |
not applicable | C128HR (DataToEncode, ApplyTilde) Returns text for Code 128 barcodes, such as for GS1-128. | IDAutomation_UniversalFont_VBA.bas or IDautomation_WindowsDLLVBA.bas and IDAutomationNativeFontEncoder.dll | Text Font |
Code-39 | IDAutomation_Uni_C39 (DataToEncode, N_Dimension, IncludeCheckDigit) Example: IDAutomation_Uni_C39 ('123456789', 3, TRUE ) Excel for Mac: idautomation_uni_c39 ('123456789', 3, TRUE ) | IDAutomation_UniversalFont_VBA.bas or IDautomation_WindowsDLLVBA.bas and IDAutomationNativeFontEncoder.dll | IDAutomation_Uni |
Codabar | IDAutomation_Uni_Codabar (DataToEncode, N_Dimension, StartChar, StopChar) Example: IDAutomation_Uni_Codabar ('123456789', 3,'A','B' ) Excel for Mac: idautomation_uni_codabar ('123456789', 3,'A','B' ) | IDAutomation_UniversalFont_VBA.bas or IDautomation_WindowsDLLVBA.bas and IDAutomationNativeFontEncoder.dll | IDAutomation_Uni |
Interleaved 2 of 5 | IDAutomation_Uni_I2of5 (DataToEncode, N_Dimension, IncludeCheckDigit) | IDAutomation_UniversalFont_VBA.bas or IDautomation_WindowsDLLVBA.bas and IDAutomationNativeFontEncoder.dll | IDAutomation_Uni |
MSI / Plessey | IDAutomation_Uni_MSI (DataToEncode, N_Dimension, IncludeCheckDigit) | IDAutomation_UniversalFont_VBA.bas or IDautomation_WindowsDLLVBA.bas and IDAutomationNativeFontEncoder.dll | IDAutomation_Uni |
USPS IntelligentMail | IDAutomation_Uni_IntelligentMail (DataToEncode) ** | IDAutomation_UniversalFont_USPS_IMb_VBA.bas | IDAutomation_Uni |
USPS Postnet | IDAutomation_Uni_Postnet (DataToEncode, IncludeCheckDigit) | IDAutomation_UniversalFont_VBA.bas or IDautomation_WindowsDLLVBA.bas and IDAutomationNativeFontEncoder.dll | IDAutomation_Uni |
USPS Planet | IDAutomation_Uni_Planet (DataToEncode, IncludeCheckDigit) | IDAutomation_UniversalFont_VBA.bas or IDautomation_WindowsDLLVBA.bas and IDAutomationNativeFontEncoder.dll | IDAutomation_Uni |
Functions for the DataBar Barcode Font | |||
The functions listed below are preceded with IDAutomation_GS1 and are only provided with the IDAutomation DataBar Font Advantage Package. | |||
Barcode Type | DataBar Barcode Function Methods | Notes | VBA File to Import | Required Font |
DataBar | DataBar (DataToEncode) | IDAutomationGS1DataBar.bas | IDAutomation DataBar 34 |
DataBar Expanded | DataBarExpanded (DataToEncode, 22) | IDAutomationGS1DataBar.bas | IDAutomation DataBar 34 |
DataBar Exp. Stacked | DataBarExpanded (DataToEncode, Segments) | IDAutomationGS1DataBar.bas | IDAutomation DataBar 34 |
DataBar Stacked Omnidirectional | DataBarStacked (DataToEncode) | IDAutomationGS1DataBar.bas | IDAutomation DataBar 34 |
The functions listed below are rare and not approved for POS systems. | |||
DataBar Limited | DataBarLimited (DataToEncode) (Not approved for POS) | IDAutomationNativeWindowsDLLVBA.bas and IDAutomationNativeFontEncoder.dll | IDAutomation DataBar 13 |
DataBar Stacked | DataBarStacked (DataToEncode) (Not approved for POS) | IDAutomationNativeWindowsDLLVBA.bas and IDAutomationNativeFontEncoder.dll | IDAutomation DataBar 13 |
DataBar Truncated | DataBar (DataToEncode) (Not approved for POS) | IDAutomationNativeWindowsDLLVBA.bas and IDAutomationNativeFontEncoder.dll | IDAutomation DataBar 13 |
2D Font Functions | |||
Regarding all symbologies listed in this section below:
| |||
Barcode Type | 2D Function Methods | Notes | VBA File to Import | Required Font |
Data Matrix | IDAutomation_DMatrix_FontEncoder(DataToEncode As String, Optional ProcessTilde, Optional EncodingMode, Optional PreferredFormat) Complete VBA is only provided in the purchased version. | IDAutomation_DM_FontEncoder.bas (2020 Release) | IDAutomation2D or IDAutomationDMatrix |
EncDM(DataToEncode As String, Optional ProcessTilde, Optional EncodingMode, Optional PreferredFormat) | IDAutomation_Datamatrix_ActiveX_Macro.bas and IDAutomationDMatrix.dll (Legacy ActiveX Version) | ||
QR-Code | IDAutomation_QRFontEncoder(DataToEncode) All parameters are set to default except ApplyTilde which is set to 1. | IDAutomation_VBA_QRCode_FE2021 (2021 Release) | IDAutomation2D |
PDF417 | IDAutomation_PDF417(DataToEncode As String, Optional EccLevel As Integer, Optional ColumnSpecify As Integer, Optional RowSpecify As Integer, Optional Truncate As Integer, Optional ForceBinary As Integer) As String | IDAutomation_Native_PDF417_Macro.bas | IDAutomation2D or IDAutomationPDF417 |
IDAutomation_PDF417(DataToEncode As String, Optional EcLevel As Integer, Optional TotalColumns As Integer, Optional TotalRows As Integer, Optional Truncated As Integer, Optional PDFMode As Integer, Optional ApplyTilde As Integer) As String | IDAutomation_PDF417_Macro.bas and IDAutomationPDF417.dll (Legacy ActiveX Version) | ||
Aztec | EncAztec(DataToEncode As String, Optional ProcessTilde, Optional Error Correction) | IDAutomation_Aztec_Macro.bas and IDAutomationAztec.dll | IDAutomation2D |
Maxicode | EncMC(DataToEncode as String, Optional EncodingMode as Int) The default Encoding Mode is 2 | IDAutomation_MaxiCode_Macros.bas | IDAutomation Maxicode |