New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions Bookmark and Share
Roxanne

Dec-2013 Font Tool Update: Microsoft Office Bar Code Macros & VBA Functions

Update to the IDAutomationVBA.bas file free font encoder. The new VBA will have the ability to encode data for HIBC (a competitor of GS1) Code 128, which is a medical labeling standard - similar to the HIBC Code 39. The HIBC Code 128 standard is a bit different than a normal Code 128 as it requires a MOD 43 check digit and certain prefix characters. The VBA update is specific to Code 128 and includes three new ReturnTypes.

HIBC Code 128 includes a Primary Barcode and can sometimes include a Secondary Barcode (each type will hold different fields of data).


PRIMARY BARCODE
To create a Primary barcode, using B123120001 as the sample data, the user will import the VBA into Excel and call the =Code128("B123120001",10,False) function and set the Return Type to 10.

This will add an identifier prefix "+" to the data and calculate the Mod43 function check character.

For example: Encoding B123120001 will produce a Primary barcode that scans as +B123120001J


CHECK CHARACTER
The check character produced from the Primary barcode but must be part of the Secondary barcode DataToEncode. The newly defined Return Type 11 takes the Primary barcode DataToEncode and returns only the check character when in normal font.

For example: =Code128("B123120001",11,False) produces J. Let's say this check digit is stored in C3 in Excel, for the next example.


SECONDARY BARCODE
To create the Secondary barcode, using 01181234555 as the sample data, the user will import the VBA into Excel and call the =Code128("01181234555 & C3",12,False) function, where C3 was the Mod 43 check character from the Primary barcode, and the Return Type is set to 12.

The Secondary barcode runs the same process as the Primary barcode except that it adds the prefix "+$$+". The user must append the Primary barcode check character by either appending the cell that was used to calculate it for Return Type 11 or add it manually to the DataToEncode.

For example: Encoding 01181234555 and appending the Primary check character (example uses J) will produce a Secondary barcode that scans as +$$+01181234555J%


12-06-13     2027 day(s) ago    

  Report Abuse

 

Roxanne

Best Answer

More information and most up-to-date version to download is located at:
https://www.idautomation.com/font-encoders/vba-macro/

Posted 2027 day(s) ago

()
()
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.

Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2019 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook