Serving the Quantitative Finance Community

Search found 5 matches

by pje
March 3rd, 2006, 2:52 pm
Forum: Programming and Software Forum
Topic: ExcelDna - open-source Excel/.Net integration
Replies: 15
Views: 132703

ExcelDna - open-source Excel/.Net integration

<t>I have experimented with you interface. I like it a lot. It’s nice not to have to mess around with xlopers.Is it possible to relax the .net v2.0 requirement? I would like to be able to use the interface with .net 1.1. Is it the scripting which uses Reflection the main driver for using 2.0? Are th...
by pje
February 14th, 2006, 11:26 am
Forum: Programming and Software Forum
Topic: Calling VBA functions from XLL
Replies: 10
Views: 125994

Calling VBA functions from XLL

<t>I have finally got it working.You can call functions written in VBA or from another addin by using the following code in an XLL. (Not a built in excel function)XlfExcel::Instance().Call(xlUDF,res2,2,XlfOper("mytest"),XlfOper(4.0));I knew it would be simple, as these things are once you know the a...
by pje
February 9th, 2006, 9:10 am
Forum: Programming and Software Forum
Topic: Calling VBA functions from XLL
Replies: 10
Views: 125994

Calling VBA functions from XLL

<t>Thanks for the suggestion. I can see that it would work for the integration problem, but where I also need to call an existing addin I am not sure how you would obtain the address of the function.I have now managed to call a vba udf from an xll…Using the xlw library I have written the following c...
by pje
February 8th, 2006, 11:04 am
Forum: Programming and Software Forum
Topic: Calling VBA functions from XLL
Replies: 10
Views: 125994

Calling VBA functions from XLL

<t>Hi,Thanks for your reply.I would like to be able to call functions from a different addin as there is an existing addin that creates object handles and has functions for operating on these handles (standard bank toolkit). I want to create a new addin that can be passed these handles, call the exi...
by pje
February 8th, 2006, 9:55 am
Forum: Programming and Software Forum
Topic: Calling VBA functions from XLL
Replies: 10
Views: 125994

Calling VBA functions from XLL

<t>Hi,I would like to be able to call functions written in VBA and in existing Add-ins from a XLL, is this possible?For example, I have a library of integration routines in C++ that I would like to be able to use in VBA. I am hoping it is possible to pass a string of the VBA function name to the XLL...