Using dll with a dynamic link in VB

J

jul

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

C-DLL-VBA to excel (strings) 0
Passing an array of strings from VBA to C 1
C-DLL-VBA-EXCEL strings 0
Is there anyway of using a calendar similar to the VB version in e 1
Assign a sound to a variable 19
Problem using DLL written in C++ 0
Can I still register a function in a DLL using ExecuteExcel4Macro REGISTER? 6
Type checking from VBA to C++? 2

Top