Earn Points & Redeem with attractive offers!
You can earn points, by asking, answering, voting questions and redeem with
attractive offers
. To view various available redemption schemes, please visit
"My Profile".
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
Ask
Ask a question. Make sure you select the correct category for the question.
Answer
Like to help others? Then browse through the open questions to answer their questions.
Find
Find answer by browsing the resolved questions.
     
Search for Questions:
My Profile

Jsadams

Resolved Questions Bookmark and Share

Setting Barcode Properties When Using the Excel Add-In

We are using the Data Matrix Barcode Font Package. While using it in combination with a mailmerge, 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     301 day(s) ago     Views: 435

    Report Abuse

 

James

Best Answer

Try the following (choose one or the other):

1. Using the Add-In:
image

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 300 day(s) ago

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

Jsadams
I cant 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 any way I pass the additional variable to the function results in a #Value error.

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




Posted 300 day(s) ago

()
()
   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 301 day(s) ago

()
()
   Report Abuse
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://")
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:// ")
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 2017 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