.Net DLL vs Excel VBA

[Grumpy Aero Guy]

I have created a simple dll via a class project in VB.Net with a few
(trivial) properties and methods.

I create/build the DLL....NO PROBLEM.

I try to set reference to this DLL via Excel 2003, and recieve an error
message indicating that this type of library is "not supported", or
something to that effect.....


(any ideas why? / am i missing something / is this a bonehead moment ? )

The same exercise using a VB6 generated DLL works problem free....

 

[Herfried K. Wagner [MVP]]

I have created a simple dll via a class project in VB.Net with a few
(trivial) properties and methods.

I create/build the DLL....NO PROBLEM.

I try to set reference to this DLL via Excel 2003, and recieve an error
message indicating that this type of library is "not supported", or
something to that effect.....

Are you sure you checked the option "Register for COM interop" in the
project properties? Have a look at the 'ComVisibleAttribute' and the
'ComClassAttribute' in the docs too.

 

[Grumpy Aero Guy]

I'm not sure I did ANY of that, but you've given me a place to start
looking....Thank you for your time.

--


Frank Bachman
(Grumpy Aero Guy)