Lib parameter in Function Declare

[ojv]

I call a DLL in an addin using the

Declare Function xxx Lib yyy ....

I do not know the full name for the library until i have interrogated
registry. Is it somehow possible to set the full name for the library in the
Declare Function statement after I have started runnig the AddIn?

ojv

 

[NickHK]

If you are asking how to call a function in a standard DLL, then you must
have the function name, library name and signature to make the declaration.
Unless you try the CALL worksheet function, but IIRC this was disable in
XL2K and later.

If it is an Addin that is installed, then you should know its functions.
If it is not installed, you can install it, but how do you know what it does
?

If this is an ActiveX DLL, you can use late binding, but you still need to
know what properties/methods it exposes.
Unless you work with CallByName and/or reading the Type Library etc.

Expalin more of which type this DLL is and how/why you only get the info
from the registry.

NickHK

 

[ojv]

I have an application which is installed on a machine at a user defined
location. This application includes a dll which is used with an Excel addin
to import data from an SQLite database. When the application is installed on
a PC it writes to registry its location. I interrogate registry from the
Excel addin to get executables and launch them via the Shell function. This
works fine. But I do not understand how to do this with a DLL unless i know
the full file name - which I do not.

How would I use late binding to access a given function in the dll?

ojv

 

[Peter T]

Did you try the suggestion I gave yesterday to your similar post.

Regards,
Peter T

 

[ojv]

Yes I have. Of course it worked. Thanks a lot.

ojv