Resolved Questions

Jsadams

Setting Barcode Properties When Using the Excel Add-In

Tagged With:-

We are using the Data Matrix Barcode Font Package. While using it in combination with a mail merge, I cannot discover how to preset the format of the DataMatrix barcodes (such as 20 x 20). It appears that the Addin automatically determines what the size should be when the conversion is made.

I realize that if a larger size is needed, the add-in will automatically increase the format to the smallest size that will fit the information being encoded, but I would like to be able to force smaller amounts of information to be encoded into a larger format, for standardization.

Can you provide some guidance?

Operating System: Windows

Application: Excel, Word

02-14-17 7.1 year(s) ago

Report Abuse


James	Best Answer Try the following (choose one or the other): 1. Using the Add-In: • In green: Remove the _ASCII bit of the function name. • In red: Press Fx and enter the Preferred Format parameter number you wish to use. 2. Using the VBA: • Uninstall the Add-In • Post: How to encode Data Matrix Barcodes using VBA in Excel • The VBA file is generally located in the .zip download: IntegrationExcel & Access VBAIDAutomation_Datamatrix_Macro.bas • General VBA instructions Posted 7.1 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.

Other Answers (2)

Jsadams

I can't seem to find any details on the configuration of the EncDM_ASCII() function that the add-in uses, to figure out how to pass the format option to it. I tried experimenting to see if I could guess at it, but modifications end in a #VALUE error in Excel.

How would I modify the below entry to indicate a 24x24 format?

=EncDM_Ascii("Testing")

The table indicates that the format number is 7, but anyway I pass the additional variable to the function resulting in a #Value error.

=EncDM_Ascii("Testing", 7) results in a #Value

Posted 7.1 year(s) ago

(0)

Report Abuse

James

Try and modify the Add-In function, similar to this post, but change the PreferredFormat property*.

*The Formats can be generally found here.

Posted 7.1 year(s) ago

(0)

Report Abuse

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.