What do you mean by 'address'? Do you mean location within the filing system?
If yes, the location is irrelevant. A DLL is registered before it can be
used: if it needs to be overwritten, it must be overwritten at the same
location.

If a user wants to work with another copy in another location, the DLL must
be unregistered and registered from the new location.

If you are using "Declare Function ...", your DLL is a WIN32 DLL. The other
kind is an ActiveX DLL. Both kinds require registration.

"jul" wrote:

I have a function in a dll (built in C) that is called through Excel VBA.

Currently I declare my function in VB as follows:
Declare Function MyFunction Lib "C:\MyDll.dll" (ByVal ...) as Integer

Yet, I would like the user to be able to specify the adress of the dll in
excel (via a message box or a cell).

How can I change the link "C:\MyDll.dll" in a dynamic way in VBA.

Many thanks in advance

Julien