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
PBell

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     1536 day(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 1536 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 (5)

PBell
Thank you - that worked.

Posted 1535 day(s) ago

()
()
   Report Abuse

James
The Code 128 Auto function has the following parameters:

=Code128 (DataToEncode, ReturnType, ApplyTilde)

Posted 1536 day(s) ago

()
()
   Report Abuse

PBell
What exactly do you mean by this? Is this a setting somewhere?

Posted 1536 day(s) ago

()
()
   Report Abuse

James
Use the Code 128 Auto function with the ReturnType set to 0 and ApplyTilde set to 1.

Posted 1536 day(s) ago

()
()
   Report Abuse

PBell
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 1536 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://" 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 2019 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