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

Excel VBA Error After Windows Upgrade


I recently upgraded to a newer version of Windows.

Before the upgrade, I was able to encode barcodes in Excel (I had previously imported the VBA’s .bas file to the worksheet).

Since the upgrade, I have installed the Code 128 Fonts and I can see barcodes, the same as before.

Now, if I make any changes, I get a NAME error in Excel.

Can you advise what to do?

Operating System: Windows

Application: Excel

09-30-15     9 year(s) ago    

  Report Abuse

 

James

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.

Please make sure:
· The VBA’s .bas file is attached to the Excel file.
· The Excel worksheet is saved as an Excel macro-enabled workbook (.xlsm).

You will then be able to see the VBA functions, using fx and navigating to User Defined functions category.

Posted 9 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 (5)
Thank you - that worked.

Posted 9 year(s) ago

(0)
(0)
   Report Abuse
The Code 128 Auto function has the following parameters:

=Code128 (DataToEncode, ReturnType, ApplyTilde)

Posted 9 year(s) ago

(0)
(0)
   Report Abuse
What exactly do you mean by this? Is this a setting somewhere?

Posted 9 year(s) ago

(0)
(0)
   Report Abuse
Use the Code 128 Auto function with the ReturnType set to 0 and ApplyTilde set to 1.

Posted 9 year(s) ago

(0)
(0)
   Report Abuse
Ok, saving as a macro enabled workbook has fixed the name issue, but now my encoded tab key using ~009 scans as ~009 instead of inserting a tab?



Posted 9 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