Have a look at this thread
excel - How should I make my VBA code compatible with 64-bit Windows? - Stack Overflow

There are actually other declarations in older code that fail when used on more modern 64-bit systems. This page compiled by Jan Karel Pieterse lists all the code I've needed (so far) to adapt my templates Declaring API functions for 64 bit Office (and Mac Office)

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia