When using the VBClient macros with CHEMCAD, the following error is encountered in 64bit systems:
It is very easy to edit the VBClient macros to run in 64bit systems. When this error is encountered, the VBA dialog also automatically pops up. And on this dialog, the code with the errors are already highlighted.
In order to fix this error, the Declare statements have to be marked with a PtrSafe attribute as stated in the error message. That means simply adding „PtrSafe“ after the Declare statement to all three declarations under the Modules>ExploreDialog in the VBAProject. The resulting code looks like the following:
After making this small change, the macros of VBClient.xls can also run in 64bit systems.