Solved

How Do I get my VB.NET DLL functions to show up in VBA Object Browser?

Posted on 2010-11-26
3
569 Views
Last Modified: 2013-11-25
I recently coded a VB.NET class in Visual Studio 2010 which has a bunch of public functions in them.  I compiled the DLL and referenced it in Excel VBA.  I can see the class name in the object browser, and I can see a public structure I have in the DLL, but none of the functions in the class are visible in the object browser.

What's funny is that I can create an instance of the class and call the functions, but none of the functions show up in Intellisense.  How can I get those functions to show up in the object browser?  Is this an issue of late vs. early binding?
0
Comment
Question by:BladdyK
  • 2
3 Comments
 
LVL 74

Accepted Solution

by:
käµfm³d   👽 earned 125 total points
Comment Utility
You have to decorate your class with the following attribute:

    [ClassInterface(ClassInterfaceType.None)]

as discussed on this thread:  http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26450356.html
0
 

Author Comment

by:BladdyK
Comment Utility
That definitely helped.  The other missing component was to create an interface for my class.  When I did that, I could see all of the functions in the Object Browser.

Thanks!
0
 

Author Closing Comment

by:BladdyK
Comment Utility
The solution was half of what I needed.  It was necessary to decorate my class, but I also need to implement an Interface to show the various functions in the object browser.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now