.Net DLL vs Excel VBA

  • Thread starter Thread starter Grumpy Aero Guy
  • Start date Start date
G

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....
 
* "Grumpy Aero Guy said:
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.....
Click to expand...

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.
 
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)
 
Back
Top