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

DataMatrix Codes incorrectly Generated in Excel using COM


I am trying to encode the following data (in cell A3) as a Type 9 Datamatrix
JGB 311100000000000001BS11DB9Z 0HP11SH
I have set the barcode cell to (Font is IDAutomation2D XLS, size 8)
=EncDM(A3,0,1,9)
(Note - The Excel file has the Bas file loaded and the reference set)
When I scan the generated Datamatrix code I get the following
JGB 311100000000000001BS11DB9Z 0HP11SH GRJHR2PW5C#Y6cD0UKGBRPGYYM1I38R8FU N5KUEP
If I use the standalone application that came with the suite the same data generates the barcode correctly
Note: I am using the same scanner both times (I have also tried some Phone apps which achieve the same outcome)
The scanner output I get from the standalone barcode app I get:
JGB 311100000000000001BS11DB9Z 0HP11SH
Can anyone tell me where I have gone wrong, please?

Operating System: Windows 10

Application: Excel (64Bit)

05-08-21     167 day(s) ago    

  Report Abuse

 

admin

Best Answer

Try to encode the data directly as a process of elimination. For example, try:
=EncDM("JGB 311100000000000001BS11DB9Z 0HP11SH")
and see if that works. If it does, the problem is not the encoder, but something in the formula.

In the Data Matrix Font and Encoder, the EncDM function uses ActiveX and is considered legacy. The latest version uses pure VBA code that will work better in Excel and on the Mac also. That funciton is:
IDAutomation_DMatrix_FontEncoder(DataToEncode As String, Optional ApplyTilde As Integer = 1, Optional EncodingMode As Integer = 3, Optional preferredFormat As Integer = -1, Optional NewLineCharacter As String = vbCrLf)
To obtain the latest version, purchase Level 2 Support.

Posted 167 day(s) ago

(0)
(0)
  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 2021 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