Resolved Questions

Roxanne

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

Tagged With:-

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 is 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 adding 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 10.8 year(s) ago

Report Abuse


Roxanne	Best Answer More information and the most up-to-date version to download is located at: https://www.idautomation.com/font-encoders/vba-macro/ Posted 10.8 year(s) ago (0) (0) Report Abuse

Find Interesting

Email to Others

Bookmark

Subscribe to Answer Alert

Add Comment

No comments yet. Be the first to comment.

Categories

» Barcode Applications » Barcode Components ● Barcode FAQ » Barcode Fonts » Barcode Hardware ● Barcode Learning » Font Encoders ● General License Questions ● General Sales Questions » MICR & OCR Fonts » Other ● Product Updates » Saas Hosted Products

Email this question link to friends

Your comment on this question

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

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

My Profile

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