Calling .Net DLL functions in Excel 2003

[Grumpy Aero Guy]

Is it possible to call functions wrapped in a DLL created via VS 2003
(Academic) from within an Excel 2003 Module via VBA (Declare Statement in
Excel VBA)?

I know this works with DLLs wrapped with VB6.0P.

I have looked on MSDN, but have no clue where to start searching.
--
Grumpy Aero Guy

[Herfried K. Wagner [MVP]]

"Grumpy Aero Guy" <[e-mail]> schrieb:

Is it possible to call functions wrapped in a DLL created via VS 2003
(Academic) from within an Excel 2003 Module via VBA
Yes. Enable the "Register for COM interop" checkbox in the project
properties. Compile the project. Add a COM reference to the interop type
library (TLB) that has been created for the .NET DLL.
(Declare Statement in Excel VBA)?

No, simply add a reference to the type library (not the DLL file).

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Grumpy Aero Guy]

Thank you... I'll give it a shot (something else to play with ! )

--
Grumpy Aero Guy

"Grumpy Aero Guy" <[e-mail]> wrote in message
news:fv*******************@tornado.ohiordc.rr.com. ..

Is it possible to call functions wrapped in a DLL created via VS 2003
(Academic) from within an Excel 2003 Module via VBA (Declare Statement in
Excel VBA)?

I know this works with DLLs wrapped with VB6.0P.

I have looked on MSDN, but have no clue where to start searching.
--
Grumpy Aero Guy

[Grumpy Aero Guy]

Works GREAT...

I really appreciate your concise and knowledgeable answers.

Now, is the type library "independent", or does the DLL need to be there as
well, once reference is set ... (?)

Enquiring minds want to know :-)

Frank B.

--
Grumpy Aero Guy

"Grumpy Aero Guy" <[e-mail]> wrote in message
news:fv*******************@tornado.ohiordc.rr.com. ..

Is it possible to call functions wrapped in a DLL created via VS 2003
(Academic) from within an Excel 2003 Module via VBA (Declare Statement in
Excel VBA)?

I know this works with DLLs wrapped with VB6.0P.

I have looked on MSDN, but have no clue where to start searching.
--
Grumpy Aero Guy

[M. Posseth]

The type library only defines the interface that is contained in the dll

So the answer is you need the Dll ( not necesary is the type library , as
it is only handy for developers who can set a reference to it without
actually installing the app on the dev system )
P.s.

Note that you need to use regasm to register the .Net COM assembly on
target systems ( on your dev machine VS.net takes care of that )
regards

Michel Posseth

"Grumpy Aero Guy" wrote:

Works GREAT...

I really appreciate your concise and knowledgeable answers.

Now, is the type library "independent", or does the DLL need to be there as
well, once reference is set ... (?)

Enquiring minds want to know :-)

Frank B.

--
Grumpy Aero Guy

"Grumpy Aero Guy" <[e-mail]> wrote in message
news:fv*******************@tornado.ohiordc.rr.com. ..

Is it possible to call functions wrapped in a DLL created via VS 2003
(Academic) from within an Excel 2003 Module via VBA (Declare Statement in
Excel VBA)?

I know this works with DLLs wrapped with VB6.0P.

I have looked on MSDN, but have no clue where to start searching.
--
Grumpy Aero Guy