Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create User Defined Function with VB.Net
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create User Defined Function with VB.Net
Have a look at
http://www.cpearson.com/excel/Creati...nctionLib.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) On Sat, 15 Aug 2009 15:49:01 -0700, Troy wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create User Defined Function with VB.Net
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" wrote: Have a look at http://www.cpearson.com/excel/Creati...nctionLib.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) On Sat, 15 Aug 2009 15:49:01 -0700, Troy wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create User Defined Function with VB.Net
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) On Sat, 15 Aug 2009 19:01:01 -0700, Troy wrote: 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" wrote: Have a look at http://www.cpearson.com/excel/Creati...nctionLib.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) On Sat, 15 Aug 2009 15:49:01 -0700, Troy wrote: 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create User Defined Function with VB.Net
I've got vs2005 standard edition at home so I'll give that a shot. Thanks
Troy "Chip Pearson" wrote: 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) On Sat, 15 Aug 2009 19:01:01 -0700, Troy wrote: 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" wrote: Have a look at http://www.cpearson.com/excel/Creati...nctionLib.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) On Sat, 15 Aug 2009 15:49:01 -0700, Troy wrote: 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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create User Defined Function with VB.Net
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, "Chip Pearson" wrote: 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) On Sat, 15 Aug 2009 19:01:01 -0700, Troy wrote: 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" wrote: Have a look at http://www.cpearson.com/excel/Creati...nctionLib.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) On Sat, 15 Aug 2009 15:49:01 -0700, Troy wrote: 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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create User Defined Function with VB.Net
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" wrote: 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) On Sat, 15 Aug 2009 19:01:01 -0700, Troy wrote: 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" wrote: Have a look at http://www.cpearson.com/excel/Creati...nctionLib.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) On Sat, 15 Aug 2009 15:49:01 -0700, Troy wrote: 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. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create User Defined Function with VB.Net
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) On Sun, 16 Aug 2009 14:38:01 -0700, Troy wrote: 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" wrote: 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) On Sat, 15 Aug 2009 19:01:01 -0700, Troy wrote: 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" wrote: Have a look at http://www.cpearson.com/excel/Creati...nctionLib.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) On Sat, 15 Aug 2009 15:49:01 -0700, Troy wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a user-defined function | Excel Programming | |||
How can I create a user defined function in excel? | Excel Discussion (Misc queries) | |||
How to create User Defined function in Excel | Excel Programming | |||
How to create User Defined Function | Excel Programming | |||
Create help for user-defined function | Excel Programming |