Serving the Quantitative Finance Community

 
User avatar
Monkey
Topic Author
Posts: 1
Joined: July 1st, 2002, 9:42 am

Best way to add functionality to Excel

February 5th, 2003, 9:51 am

I've written a couple of routines that I would now like to access from within an Excel worksheet (and maybe Word but that is not a requirement). They are currently written in VB.net and I'm looking for advice on the best way to proceed. Thus the question is: What are the options for adding functionality to Excel.I know that VBA is a nice way to start but I'm interested in knowing what other choices I have. Creating an XLL from C/C++ is also an option I've toyed with, but would really like to know if its possible to create something from VB.net that is callable within Excel.If C/C++ is the prefered solution given its pro's and cons, can somebody let me know if there is a sample for the .net framework available as a starting point.Thanks, and sorry if this is a bit disjoint, i'm new to this.ThanksMonkey
 
User avatar
jens
Posts: 0
Joined: July 14th, 2002, 3:00 am

Best way to add functionality to Excel

February 5th, 2003, 10:03 am

Try this: Understanding Classic COM Interoperability With .NET ApplicationsJens.