Problem with external DLL in VBA
I have an office 2016 x64, and somehow when I try to use the external DLL, I'm fighting that DLL is not found. I tried to clearly indicate the way, but I didn't.
Office 2010 x32 is working well.
The only difference in the code is the use of ptrsafe in x64.
What's the problem? Isn't x32 fully compatible with x64? And a mistake would be different, I think if it was a matter of default.
For external DLL in the 64th discharge office, the DLL itself should be 64th grade. Alas, the 32nd DLL will not work. That is why the support of most ActiveX components available at the 32nd grade office disappeared in the 64th DS.
If there is no possibility of overlapping the DLL, it may be possible to try to circumvent the problem through the establishment of the 64th discharge plug, the 32nd calibre and to share data between them through the IPC. For example, https://blog.mattmags.com/2007/06/30/accessing-32-bit-dlls-from-64-bit-code/ but I'm afraid the solution will be too complicated.