.xla in multiple 64/32 bits enviornments.

I have an .xla that was written on a 64-bit Windows computer running a 32-bit version of Excel. When I moved it to a 64-bit Windows computer running a 64-bit version of Excel, it would not run due to the Declare Functions. Using Microsoft's Code Inspector, an updated version for about half the Functions was suggested. The other half were commented by the Code Inspector as "NO EXACT MATCH".  I was able to get these to work by changing any parameters that were passed ByVal and were of type Long to type LongPtr.
The .xla now runs fine in both environments, but it does not run--or I should say partially runs--on a Windows 64-bit computer with a 32-bit version of Excel 2016.  By "partially runs" I mean there are no errors, but the add-in does not appear in the ribbon, and when I try to view the code, there is no code.
Confused and exhausted!
Any suggestions?
rrhandle8Asked:
Who is Participating?

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

x
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.

Jan Karel PieterseExcel and VBA ExpertCommented:
See:
http://jkp-ads.com/Articles/apideclarations.asp 
perhaps the missing ones are there? Also, the article shows how to conditionally declare the functions so they run on both 32 and 64 bit.
0

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
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
Windows OS

From novice to tech pro — start learning today.