Compile error on 64bit Office - Declare statements need to be updated

Question

When I opened Endonte Manuscript Templates, I received an error, "The code in this project must be updated for use on 64 bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute".
What should I do next?

Answer 1

In the VBA editor select Replace from the Edit menu and for the Current Project find and replace all instances of Declare Function with Declare PtrSafe Function. Do the same to replace Declare Sub with Declare PtrSafe Sub.

It's possible, but probably unlikely, that some functions or sub-procedures might still be incompatible with the 64 bit Office environment, and would need to be replaced with other methodologies.

Answer 2

You need to give us more information than that. What didn't work? Have you done a Find in the VBA editor to check whether all the relevant routines have been amended or not? If they have, are you still incurring a compilation error?