Resolved Questions

anonymous

#NAME? error in Excel using VBA Font Encoder

Tagged With:-

I purchased a Barcode Font and tried to perform a merge with Word and Excel. However, my barcode column just displays #NAME? error when trying to access the VBA function. This also happens when I try to merge with Word.

Application: Excel

02-15-12 12.7 year(s) ago

Report Abuse


Brant	Best Answer The #NAME error occurs when Excel does not recognize the function being called in a cell. When using IDAutomation fonts in Excel, the call of a function is usually necessary to format text data to the barcode font. This function call can only be executed after the appropriate add-in or VBA module is installed. A few suggestions to solve this issue are: 1. Ensure the VBA Module is properly installed. 2. Verify the module is only installed once; installing the same module twice will cause the functions to fail. 3. Ensure the Security Level allows the VBA Module or add-in to function. 4. Verify the proper spelling of the function. 5. Make sure the function name and module names are not the same; they must be different. 6. For all IDAutomation products, try the Excel Example if it is available and compare it to a working example. 7. Restart Excel to see if this resolves the issue. The following articles provide additional solutions to this particular issue: * How to correct a #NAME? error (Official Microsoft Support Link) * #Name error when the module is the same name as the function ALTERNATE PRODUCT SOLUTION 2016 Update : A new product (Native Barcode Generator for Excel) has been released since this post was resolved that offers an easier method of generating barcodes in Excel. Posted 12.7 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.

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.