Create User Defined Function with VB.Net

[Troy]

Is there a good example of creating a User Defined Function(s) with VB.Net?
I've tried creating a class library and building a .dll, but I could not
register it with
excel. Any help would be appreciated.

 

[Chip Pearson]

Have a look at
http://www.cpearson.com/excel/CreatingNETFunctionLib.aspx

That page explains how to do it and includes a complete VS2008
solution for example code.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Troy]

I've went through the tutorial but when I got to the part that requires you
to Start
External Program (Excel) in the Properties/Debug, thats a problem. That
option is not available. At least not in VB2008 Express. Is there a way to do
it with Express?
I use the Professional Edition at work however I'm trying to prove this
method at home.

Thanks

Troy

 

[Chip Pearson]

I believe that the Start External Program option is not available in
the Express edition of VS2008.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Troy]

I've got vs2005 standard edition at home so I'll give that a shot. Thanks

Troy

 

[Troy]

I've downloaded you vb example code however a password is required after I
try to open it in Visual Studio. Could you share the password?

Thank you,

 

[Troy]

Ok i've done everything so far with the tutorial excel start up just fine, I
created my .pfx in the project, etc. You say to unload the addin. Do you mean
under (Excel Options) (Add-ins)? I'm not seeing anything to unload. I think
i'm just about there but i cannot see the functions.

 

[Chip Pearson]

Once you've created and built the NET class library, create a
Deployment project and add the class library DLL to the list of
required files. Build the Setup project. Then, run the Setup.exe
program that was created by the Setup project build. Once the
Setup.exe has run, open Excel, and then open the Add-Ins dialog. Click
the Automation button and find the NET class in the list and click OK.
If you get a message like "cannot find mscore, delete from list?"
click No.

Now, you can use the functions in the class lib directly from
worksheet cells.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)