Accessing VB.Net functions from Excel

Question

I am trying to get a VB.Net DLL function exposed as a COM to work in Excel. The post Accessing .NET functions exposed as COM in Excel was very helpful. I was able to successfully register the dll and tlb files.

The class object I created is visible to Excel, but its member is not. I am working in Windows 7-64 bit with Office 2010-32 bit. I compiled the dll for x86.

Here is the code

Namespace PRISMTest
    Public Class Test
        Public ReadOnly Property CheckExcelVersion As Integer
            Get
                Return 15
            End Get
    End Class
End Namespace

And what I see in the Excel Object Browser. Any ideas?

In the future, please post any image files as .PNG and not JPEG. PNG is a lot smaller, which matters to people reading on mobile devices. Thanks. — Ken White
– Ken White, Commented Feb 13, 2016 at 1:34

Dave T · Accepted Answer · 2016-02-16 15:26:41Z

0

I figured it out. I needed to add the following code:

answered Feb 16, 2016 at 15:26

Dave T

111 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Accessing VB.Net functions from Excel

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related