troubleshooting Question

Problem with VBA API code on 64-bit machine

Avatar of marrick13
marrick13 asked on
18 Comments1 Solution23 ViewsLast Modified:
I have a Word VBA application that one of the EE experts helped me with when I was still using my old 32-bit PC with Win 7, Now I'm on a 64-bit one running Windows 10, and have already changed the approrpriate Longs to "LongPtr" and the occurrences of "Len(cc)" to "LenB(cc)". But now, when I click the Choose Line Color (or Fill Color) I get a type mismatch error on the "RvalL = cc.rgbResult Mod 256" statement in the "Private Sub cmdLineColor_Click()" (and "Private Sub cmdFillColor_Click())" module, but only on my new 64-bit machine, not the old 32-bit one.

I don't know what else needs to be changed to get this to work on a 64-bit machine - can someone help? I don't know VBA well enough to be able to resolve this on my own.

Code is in the attachment.

Insert Shapes Application-New (64-bit).docm
Join our community to see this answer!
Unlock 1 Answer and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros