When a VBA code will not work in Excel 64bit?

I have a lot of codes and free add-ins in my machine, now that my employeer switched to 64bit of Excel.

i do not know what will work and what will not.

can anyone please explain that when the declaration of IF VBA7 etc is required?  is it required with using other window APIs like Lib "kernel32"  etc.

is there any tool that would convert a 32bit Excel VBA code to become compatible with 64bit Excel?

thanks
LVL 6
FloraAsked:
Who is Participating?
 
FloraAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.