Using Intelligent Mail Barcoding in Excel 2013

I downloaded the uspsEncoderMsOffice64-1.3.1 from the post office website . in the excel file in column P there should be a 65 character string and in column Q there should be the intelligent mail barcode but is shows #VALUE!.

Attached is a previously solved spreadsheet but when i change the values for columns J, K, L, and M the previously seen character string and Intelligent mail barcode changes to #VALUE!. I haven't changes any of the cell formatting. If i go into a cell and hit enter the same thing happens.

I checked and the encodefsb is in my library and so is the fsb module in the vba section.

Any assistance on how to fix this issue would be appreciated.

Thank you.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

byundtMechanical EngineerCommented:
Your sample workbook works for me with Excel 2013 (32-bit).

One pitfall might be downloading the wrong version of the .dll. It comes in 32-bit and 64-bit versions, and you must pick the one that matches your version of Excel. FWIW, Microsoft recommends running 32-bit Excel for better compatibility. You can do so even if you are running 64-bit Windows (as I am doing).

I can reproduce your #VALUE! error if I uncheck the reference for EncoderFSB 1.1 Type Library in the Tools...References menu item in the VBA Editor. I also had to comment out the first two statements in the FSB function code (in module FSBModule (otherwise I got a never-ending sequence of debugger errors on those two statements).

So to summarize:
1. Are you absolutely positive that you downloaded the correct version of EncoderFSB from the USPS web site?
2. Is the reference for EncoderFSB 1.1 Type Library checked? If you see (MISSING) EncoderFSB 1.1 Type Library, then you need to click the Browse button and navigate to the folder where that .dll file can be found to remove the (MISSING).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mackmi02Author Commented:
Thank you for your help. I removed the 64bit version and installed the 32bit and it works perfectly now. Thank you!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.