Hi Jul,

There isn't any way to do this that I'm aware of. I don't think it's
generally a good idea to give users the decision where to place DLLs anyway,
because it might give them the idea that they could move them later. My
advice would be to put the DLL in a folder that you know will be part of the
user's PATH environment variable, like Windows or Windows\System or
Windows\System32 depending on the OS.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


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