Hello. I Know that inv 2014 has is 64 bit and has new version of VB, but I can still use for example windows 32bit DLL (Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As LongPtr) ), but when I try to import other 32bit created in VC++, the VBA simply refuses to work. CAn anyone help? Why one 32 bit dll work and other not? I got message "File not found" where the file is 100% in good place.
Hi
On 64-bit platform, the Kernel is definitely a 64-bit dll. It's always called kernel32.dll
, even on 64-bit windows. This is for the same compatibility reasons that system32
contains 64-bit binaries, while syswow64
contains 32-bit binaries.
You will have to compile your dlls for 64-bit if you want to be able to import functions under VBA x64.
Philippe.