By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,168 Members | 2,598 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,168 IT Pros & Developers. It's quick & easy.

.Net DLL vs Excel VBA

P: n/a
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....

--
Frank Bachman
(Grumpy Aero Guy)

Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
* "Grumpy Aero Guy" <fbachman@beer_me.com> scripsit:
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.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>
<URL:http://dotnet.mvps.org/dotnet/faqs/>
Nov 20 '05 #2

P: n/a
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)
"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
* "Grumpy Aero Guy" <fbachman@beer_me.com> scripsit:
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.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>
<URL:http://dotnet.mvps.org/dotnet/faqs/>

Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.