The example I am using is C:\Users\Public\Vensim\DLL\excel97\VENDLL.XLS
When I run the "Get Vensim Info"-macro, Excel is returning a runtime error errorcode 53 - vendll32.dll not found as expected, since the 32-bit-DLL is not installed in C:\Windows\SysWOW64 folder with 64-bit Vensim.
So I changed the function declarations to call the 64-bit DLL from
Code: Select all
Private Declare Function vensim_get_info Lib "vendll32.dll" (ByVal infowanted As Long, ByVal buf$, ByVal maxbuflen As Long) As Long
Code: Select all
Private Declare Function vensim_get_info Lib "vendll64.dll" (ByVal infowanted As Long, ByVal buf$, ByVal maxbuflen As Long) As Long
Code: Select all
Private Declare Function vensim_get_info Lib "C:\Windows\System32\vendll64.dll" (ByVal infowanted As Long, ByVal buf$, ByVal maxbuflen As Long) As Long