Resolved Questions

PBell

Excel VBA Error After Windows Upgrade

Tagged With:-

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.1 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.1 year(s) ago (0) (0) Report Abuse

Find Interesting

Email to Others

Bookmark

Subscribe to Answer Alert

Add Comment

No comments yet. Be the first to comment.

Other Answers (5)

PBell

Thank you - that worked.

Posted 9.1 year(s) ago

(0)

Report Abuse

James

The Code 128 Auto function has the following parameters:

=Code128 (DataToEncode, ReturnType, ApplyTilde)

Posted 9.1 year(s) ago

(0)

Report Abuse

PBell

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

Posted 9.1 year(s) ago

(0)

Report Abuse

James

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

Posted 9.1 year(s) ago

(0)

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 9.1 year(s) ago

(0)

Report Abuse

Categories

» Barcode Applications » Barcode Components ● Barcode FAQ » Barcode Fonts » Barcode Hardware ● Barcode Learning » Font Encoders ● General License Questions ● General Sales Questions » MICR & OCR Fonts » Other ● Product Updates » Saas Hosted Products

Email this question link to friends

Your comment on this question

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

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

My Profile

You may answer and comment on any thread according to the Terms and Conditions.