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

AlanRae

Resolved Questions Bookmark and Share

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, scanner returns 90, 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     463 day(s) ago     Views: 508

    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 encoding data in Excel
A1 = 123
A2 = (three spaces)
A3 = 456

image

Result:
image



Posted 463 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)

Ben
Yes, it works with spaces at the very end of the data.

image

image

If you have additional questions, let me know.



Posted 462 day(s) ago

()
()
   Report Abuse

AlanRae
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 in to 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 462 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