<r>Hello,QuoteOriginally posted by: sebgurYes, QuantLib also has an implementation of addins for open Calc, and it even has a Visual Studio solution.I tried it. Unfortunately, the QuantLib msvc solution is version vc7, and my msvc is vc8. It tried to convert from vc7 to vc8, but that failed. Then th...

<t>Hello,QuoteOriginally posted by: MaxCohenI am guesing Objecthandler is not that user friendly, unlike XLW.The learning curve for OH is steeper than that for XLW, and XLW's automatic interface generator has no equivalent in OH.But please have a look at the example projects that ship with OH, they ...

QuoteOriginally posted by: DominicConnorIs XLW thread safe ?No but it does support the implementation of thread safe worksheet formulas in Excel 2007.Regards,Eric

<t>Hi Jeff,QuoteOriginally posted by: jjyuI can tell it starts with the length of the string, followed by the content. However, what should I put in [0][0], [0][1]? What is the format requirement? Is it documentated? What if I want to change the dialog box somewhat? That's what've bugged me thus far...

<t>Hi Jeff,QuoteOriginally posted by: jjyuMy suggestion is to bring up the debugger to see what is going on.There is a very small and very relevant piece of code which we have still yet to see, wouldn't it make sense to have a quick look at that before starting the debugger? Mark tried without succe...

<t>The original version of returnClassPI() looks OK to me and the subsequent edit shouldn't change anything.Stale mentioned an earlier implementation with no Test object which returned 3.14 and worked as expected. I see no reason why such a function should behave differently than the one shown, nor ...

<r>Hi Stale,QuoteOriginally posted by: StaleThanks for your responce eehlers and jjyu.eehler, you'll see the attached code. jjuy: The interfacegenerator is really my fried! I'm trying to figure out what would be the best approach to integrating the 00 and procedural paradigms, so if you have any poi...

<t>Hi Stale,QuoteOriginally posted by: StaleAre there restrictions using classes and XLW? Which approach should I use? The attached code is wrapped just like ordinary functions, by creating an object and then calling the method.XLW's functionality is procedural and the only way to return the value f...

<t>Hello,On your machine, place MyAddIn.xla in the same directory as MyWorkbook.xls or in a subdirectory of MyWorkbook.xls. Update the link from MyWorkbook.xls to MyAddIn.xla and save.Now when you copy the two books to another machine, if you preserve the relative path between the two, you will find...

<r>Hello,QuoteOriginally posted by: crosshatchFor Excel, I was thinking to have data in flat files (HDF5 ?) on disk and to code time series and option pricing algorithms in C++ (on top of QuantLib). I was thinking of using the ObjectHandler paradigm (<URL url="http://quantlib.org/objecthandler">http...

Hello,Set Threadsafe to true in the XlfFuncDesc constructor. If you're using the InterfaceGenerator utility to autogenerate the source code for your addin, then use the tag <xlw:threadsafe. A threadsafe addin function is provided in the example application.Regards,Eric

<t>Hello,QuoteOriginally posted by: LapsilagoDear all,I have the following problem: I want to use an external library e.g. lpsolve within the xlw framework.To this end I specify the path where the external dll is located and give the name say lpsolve.dll. Now I compile my project.Excel opens the xll...

<t>Hello,QuoteOriginally posted by: gatechfe08how do u incorporate a customised function in C++.. into MS excel through dll/xll??? i have tried everthng... doesnot work though... please help me out.... tried using sample codes on net... still does not work...Exposing a C++ function to Excel is very ...

Hello,QuoteOriginally posted by: ericlmaThanks for the tip Eric. xlUDF works perfectly under Excel 2007.No problem and good to know that xlUDF works.Regards,Eric

<t>Hello,QuoteOriginally posted by: ericlmaHas anyone used the following syntax to call VBA functions from XLL?Excel4v(xlcRun, XLOPER &xlRes, 1, TempStr("myVBAAddin.xla!myFunc"));That should be:Excel4v(xlcRun, &xlRes, 1, TempStr(" myVBAAddin.xla!myFunc"));Or with the Excel 2007 SDK: Excel4v(...