View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Lib parameter in Function Declare

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" wrote in message
...
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