Hi
I have a worksheet that uses a dll file which is installed in the Excel library and I want to change the VBA code that uses the dll file so that instead of looking up the DLL file in the excel library, it looks it up on the worksheet's folder.
Can this be done?
Note that I didn't write the VBA code on this sheet. The code is the following:
Private Declare Function VectorModel Lib "Vector.dll" (...)
Isn't it possible to do something like:
Private Declare Function VectorModel Lib "c:\Vector.dll" (...) ?
thanks in advance for your help
I have a worksheet that uses a dll file which is installed in the Excel library and I want to change the VBA code that uses the dll file so that instead of looking up the DLL file in the excel library, it looks it up on the worksheet's folder.
Can this be done?
Note that I didn't write the VBA code on this sheet. The code is the following:
Private Declare Function VectorModel Lib "Vector.dll" (...)
Isn't it possible to do something like:
Private Declare Function VectorModel Lib "c:\Vector.dll" (...) ?
thanks in advance for your help