Resolved Questions

Terry

Excel VBA Encoding

I tried implementing the VBA Font Encoder in Excel to create Code 128 barcodes. Is there something I am missing?

Operating System: Windows

Application: Excel

10-10-16 8 year(s) ago

Report Abuse


James	Best Answer *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. [Support Note: Communicated with client via chat/email.] 1. Issue: Client was previously saving Excel spreadsheets to CSV and had to keep reimporting VBA to encode data. Solution: Advised client to save their spreadsheet as an XLSM (Excel macro-enabled workbook), which allows the VBA to stay attached to spreadsheet and to export the results as a new CSV file and not overwrite original XLSM file. 2. Issue: Client saved CSV file directly to XLSM and VBA would not stay attached. Solution: Advised client that Excel could be mishandling the file conversion and that they try creating a new XLSM file, attaching the VBA to it, copying/pasting their data in, and retrying the encoding. This worked for the client. Posted 8 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

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