New User? Sign Up  |  Sign In  |  Help
IDAutomation Logo
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

Spaces at end of string being removed by Datamatrix VBA encoder for Excel


Hello, I think I may have discovered a problem with the "VBA Source for Data Font Matrix Encoder V7.01" not encoding spaces at the end of the data string.

The above VBA module is loaded in the Excel workbook and the command to encode the string is "=EncNDM(D5,0,1,12)". Each data string is made up of a concatenation of other fields, the last field containing spaces for padding purposes. The barcode appears to be successfully created and then merged to Word and the ID Automation Datamatrix font applied.

However, when verifying the 2D barcode, the last spaces are stripped out of the data string. These spaces are important as a mask is applied upon reading the code. If these last spaces are missing then the code fails as it is not what should be encoded - encoded 100 characters, the scanner returns 90, and the last 10 characters are spaces.

Interestingly, if I use the stand-alone program "ID Automation DataMatrix Font Encoder for Windows, V1.31" and encode the same 100-character string, it DOES encode the spaces!

Can you tell me why the Excel VBA module removes the last non-printable characters (spaces) when your other tool does not? Is there an update to the VBA script that fixes this bug, or is there something I am doing wrong?

Your help is greatly appreciated.

Regards, Alan

Operating System: Windows 7

Application: Microsoft Excel 2010

12-17-15     8.8 year(s) ago    

  Report Abuse

 

Ben

Best Answer

2016 Update:
A new product (Native Barcode Generator for Excel) has been released since this question was resolved that offers an easier method of generating barcodes in Excel.

The version you currently own is no longer supported by IDAutomation. You may review our latest version of the Data Matrix Font Package released in 2015.

Data Matrix Release Log

You may also demo the most recent version.


Here is an example of encoding data in Excel
A1 = 123
A2 = (three spaces)
A3 = 456

image

Result:
image

Posted 8.8 year(s) ago

(0)
(0)
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.
Other Answers (2)
Yes, it works with spaces at the very end of the data.

image

image

If you have additional questions, let me know.

Posted 8.8 year(s) ago

(0)
(0)
   Report Abuse
Thanks for your comment, Ben.

The example you posted is not the problem I'm reporting as your spaces are in the middle of the data string - it's what would happen if the spaces were at the end.

Encode this into Excel:
A1 = 123
A2 = 456
A3 = (three spaces)

The three spaces in cell A3 are not encoded.

image

Does the latest version of the Data Matrix Font Package fix this bug? I shall certainly try the latest version as long as it doesn't impact my current installation.

Regards,

Alan

Posted 8.8 year(s) ago

(0)
(0)
   Report Abuse
 Categories
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