Create a VB.net Automation Add-in for Excel 2002 WS Function

J

JohnW.

I'd like to know how to create a DLL in Visual Basic.net
containing a function library that can subsequently be
referenced by an Excel add-in and used as a custom
worksheet function in Excel 2002.

I've read HowTo: Create a Visual Basic Automation Add-in
for Excel 2002 Worksheet Functions, but it is not based
on Visual Basic.net. I've also read article 256624,
HowTo: Use a COM Add-in function as an Excel Worksheet
Function, but that only applies to Excel 2000 and VB 5.0
or VB 6.0.

I've also read the HowTo article: Build an Office COM
Add-in by Using Visual Basic.net, but the article doesn't
explain how to access the add-in from a custom worksheet
function call in Excel 2002. It also wasn't clear to me
how to register the Add-in - despite there being a
paragraph devoted to the topic.

Any help you could provide would be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel suddenly crippled by Just-In-Time Debugging 2
Excel Add-In using COM / Ole Automation 0
Compiling a COM Add-in for both Word 2002 and Word 2003 0
Automation Add-In for Excel 2002 with Visual Studio 2008 0
Error messages received when COM Add-in is load in Excel 0
Intellisense for Automation Add-In Functions 0
C# Excel Add-in UDF which returns results multiple cells 0
Adding a big matrix in Word 2013 5

Top