DLL c++
 

Hello.
I've been looking for info for a while but unfortunately I was not able to
find out anything useful

How should I create a C++ DLL so that I can referece it from VBA?
I can create functions and use them in Excel using Declare [...], but this
is not what I would like to do.
I'd like to use, from VBA, Tools-Refereces and from that form load the DLL,
but I can't do so, as I always get the same error "Unable to add a reference
to this file" (maybe words in English are not exactly those, I'm translating
from Italian...)

Many thanks,
Lorenzo

DLL c++
 

Ok, in c++ you'll have to create an active-x dll. This will allow you to
create a type library that will allow you to reference it from the
tools:references...

Sounds to me like you are creating a normal Dll which isn't COM(active-x).
If you have a normal DLL you have to use Declare .....blah blah.

Hope that points you in the right direction.

"Lore" wrote:

Hello.
I've been looking for info for a while but unfortunately I was not able to
find out anything useful

How should I create a C++ DLL so that I can referece it from VBA?
I can create functions and use them in Excel using Declare [...], but this
is not what I would like to do.
I'd like to use, from VBA, Tools-Refereces and from that form load the DLL,
but I can't do so, as I always get the same error "Unable to add a reference
to this file" (maybe words in English are not exactly those, I'm translating
from Italian...)

Many thanks,
Lorenzo

DLL c++
 

Hello Paul,
thank you. I'll try to do what you suggested...

Lorenzo


Paul G wrote:
Ok, in c++ you'll have to create an active-x dll. This will allow you to
create a type library that will allow you to reference it from the
tools:references...

Sounds to me like you are creating a normal Dll which isn't COM(active-x).
If you have a normal DLL you have to use Declare .....blah blah.

Hope that points you in the right direction.

"Lore" wrote:

Hello.
I've been looking for info for a while but unfortunately I was not able to
find out anything useful

How should I create a C++ DLL so that I can referece it from VBA?
I can create functions and use them in Excel using Declare [...], but this
is not what I would like to do.
I'd like to use, from VBA, Tools-Refereces and from that form load the DLL,
but I can't do so, as I always get the same error "Unable to add a reference
to this file" (maybe words in English are not exactly those, I'm translating
from Italian...)

Many thanks,
Lorenzo