View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Dynamic path for dll

Depending on the type of dll, try temporarily switching to the directory
containing the dll

sCur = CurDir
ChDir sPathToDll
' call dll
ChDir sCur

and don't put a path in the Declare

Regards,
Peter T

"ojv" wrote in message
...
Need to use functions from an external dll. When I start up i do not know

in
advance the location for the dll but have to query registry to get the

full
path. If I then assign this path pluss the dll name to a string variable
fullPath and use this as follows

Declare Function someFnction Lib fullPath .......

I get an error stating that the Lib must be a constant string. Is it
possible to get around this somehow when I do not know the location of the
dll on beforehand and the dll path is not included in the Path setting?