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 8 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 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.

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 8 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 8 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.