Hi,
I struggle with making lpsolve work within VBA/Excel after switching to 64-bit win11 + Excel. I have read that changing declarations in the dll to PtrSafe along with PtrLong etc etc would make it work but I fail to get it to run without crashing when calling the API and DLL.
In brief my environment:
Win 11 64-bit
Excel 365 64-bit
Generating the model and constraints in VBA, calling the lpsolve55.dll
In the best of worlds someone has a dll along with VBA code to share.
Any help would be greatly appreciated, thanks in advance.