Feb 09 2022 02:55 PM
Feb 10 2022 01:08 AM
Feb 10 2022 02:51 AM - edited Feb 10 2022 02:52 AM
You need to convert each API declaration adding PtrSafe and converting Long to LongPtr for handles and pointers.
If any users are still running A2007 or earlier you will need conditional compilation.
The likelihood is that the above info made little sense to you ... so I strongly recommend you do some research on the topic. Its a complicated topic when you first encounter the issue
There are many articles online but there is a lot of misinformation so take care.
I recommend the following article:
Windows API declarations in VBA for 64-bit - Codekabinett
Also this documentation from MS
This conversion utility may also help:
Windows API Viewer for MS Excel (rondebruin.nl)
Hope that helps
Alternatively, uninstall 64-bit Office and revert to 32-bit Office !