error on loading examples through compiled quantlib addin for Excel
Locked
error on loading examples through compiled quantlib addin for Excel
 
|
Hello all, I get the precompiled quantlib addin to work ok from within Excel (which I get through running QuantLibXL-bin-1.2.0 .exe), but I am having trouble with the addin that I have compiled myself (which I get from compiling under VS10 and Boost). When I compile the addin myself, the standalone excel examples seem to work. But when I test the framework by going to menu option "Add-Ins -> QuantLibXL -> Load -> Fixed Income" I get: Error loading fixed income environment invalid filename 'c:\build_ql_1_2_\QuantLibXL\framework\..\..\ObjectHandler\xll\ObjectHandler-xll-vc90-mt-1_1_0.xll' The big difference between my compiled addin and the pre-compiled one seems to be the name of the addin. My compiled addin’s .xll file is called: C:\build_ql_1_2_\QuantLibXL\xll\QuantLibXL-vc100-mt-s-1_1_0.xll The precompiled addin’s .xll file is called: C:\Program Files\QuantLibXL-1.2.0\xll\QuantLibXL-vc90-mt-s-1_2_0.xll What am I doing wrong? My machine is Windows 7, 32 bit. Best regards, Ted ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ QuantLib-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/quantlib-users |
Re: error on loading examples through compiled quantlib addin for Excel
|
|
Hi Ted,
On 2013-12-11 15:58, Ted Murphy wrote: > Hello all, > > I get the precompiled quantlib addin to work ok from within Excel > (which I get through running QuantLibXL-bin-1.2.0 .exe), but I am > having trouble with the addin that I have compiled myself (which I get > from compiling under VS10 and Boost). > > When I compile the addin myself, the standalone excel examples seem to > work. But when I test the framework by going to menu option "Add-Ins > -> QuantLibXL -> Load -> Fixed Income" I get: > > Error loading fixed income environment > > invalid filename > 'c:build_ql_1_2_QuantLibXLframework....ObjectHandlerxllObjectHandler-xll-vc90-mt-1_1_0.xll' > > The big difference between my compiled addin and the pre-compiled one > seems to be the name of the addin. > > My compiled addin's .xll file is called: > > C:build_ql_1_2_QuantLibXLxllQuantLibXL-vc100-mt-s-1_1_0.xll > > The precompiled addin's .xll file is called: > > C:Program FilesQuantLibXL-1.2.0xllQuantLibXL-vc90-mt-s-1_2_0.xll > > What am I doing wrong? My machine is Windows 7, 32 bit. Please edit file C:\Program Files (x86)\QuantLibXL-1.2.0\framework\config\Loader.xls and enter the new name of your addin in cell Loader!C17. Also, the error message that you are getting indicates a problem loading the ObjectHandler XLL, this message puzzles me. In the build that uses dynamic linking, there are two XLLs, one for ObjectHandler and one for QuantLibXL. In the statically linked build there is only one XLL, the QuantLibXL XLL, and the ObjectHandler functionality is statically linked into that. You appear to be using the static build, so I don't understand why it is trying to load the ObjectHandler XLL. Again in file Loader.xls, do you have an X in cell Loader!F25? If so please try deleting that. Please let us know how it goes. Kind Regards, Eric -- =================================================== Eric Ehlers nazcatech sprl | Brussels | http://www.nazcatech.be * Distributed computing for pricing analytics * Use Microsoft Excel as a client to the Grid ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ QuantLib-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/quantlib-users |
Re: error on loading examples through compiled quantlib addin for Excel
|
|
On 2013-12-12 09:12, Eric Ehlers wrote:
> Please edit file C:\Program Files > (x86)\QuantLibXL-1.2.0\framework\config\Loader.xls Oops. Since you are using the source code installation rather than the binary installation, the path to Loader.xls would be something like C:/build_ql_1_2/QuantLibXL/framework/config/Loader.xls Kind Regards, Eric -- =================================================== Eric Ehlers nazcatech sprl | Brussels | http://www.nazcatech.be * Distributed computing for pricing analytics * Use Microsoft Excel as a client to the Grid ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ QuantLib-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/quantlib-users |
Re: error on loading examples through compiled quantlib addin for Excel
|
|
In reply to this post by Eric Ehlers-2
Eric,
Thank you for your response, very much appreciated. When I edit the Loader.xls file to reflect my compiled .xll file -- and also edited the Loader.xls fields to mimic those found in the pre-compiled version of Loader.xls -- I get the following error when going to menu option "Add-Ins --> QuantLibXL -> Load -> Fixed Income" using my compiled addin: QuantLibXL Error Error activating addin menu: Object variable or With block variable not set Looks like something in the FixedIncome.xla vba code called upon loading. Best regards, Ted -----Original Message----- From: Eric Ehlers [mailto:[hidden email]] Sent: Thursday, December 12, 2013 3:12 AM To: [hidden email] Subject: Re: [Quantlib-users] error on loading examples through compiled quantlib addin for Excel Hi Ted, On 2013-12-11 15:58, Ted Murphy wrote: > Hello all, > > I get the precompiled quantlib addin to work ok from within Excel > (which I get through running QuantLibXL-bin-1.2.0 .exe), but I am > having trouble with the addin that I have compiled myself (which I get > from compiling under VS10 and Boost). > > When I compile the addin myself, the standalone excel examples seem to > work. But when I test the framework by going to menu option "Add-Ins > -> QuantLibXL -> Load -> Fixed Income" I get: > > Error loading fixed income environment > > invalid filename > 0-mt-1_1_0.xll' > > The big difference between my compiled addin and the pre-compiled one > seems to be the name of the addin. > > My compiled addin's .xll file is called: > > C:build_ql_1_2_QuantLibXLxllQuantLibXL-vc100-mt-s-1_1_0.xll > > The precompiled addin's .xll file is called: > > C:Program FilesQuantLibXL-1.2.0xllQuantLibXL-vc90-mt-s-1_2_0.xll > > What am I doing wrong? My machine is Windows 7, 32 bit. Please edit file C:\Program Files (x86)\QuantLibXL-1.2.0\framework\config\Loader.xls and enter the new name of your addin in cell Loader!C17. Also, the error message that you are getting indicates a problem loading the ObjectHandler XLL, this message puzzles me. In the build that uses dynamic linking, there are two XLLs, one for ObjectHandler and one for QuantLibXL. In the statically linked build there is only one XLL, the QuantLibXL XLL, and the ObjectHandler functionality is statically linked into that. You appear to be using the static build, so I don't understand why it is trying to load the ObjectHandler XLL. Again in file Loader.xls, do you have an X in cell Loader!F25? If so please try deleting that. Please let us know how it goes. Kind Regards, Eric -- =================================================== Eric Ehlers nazcatech sprl | Brussels | http://www.nazcatech.be * Distributed computing for pricing analytics * Use Microsoft Excel as a client to the Grid ---------------------------------------------------------------------------- -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ QuantLib-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/quantlib-users ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ QuantLib-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/quantlib-users |
Re: error on loading examples through compiled quantlib addin for Excel
|
|
Hi Ted,
On 2013-12-12 15:00, Ted Murphy wrote: > Thank you for your response, very much appreciated. When I edit the > Loader.xls file to reflect my compiled .xll file -- and also edited the > Loader.xls fields to mimic those found in the pre-compiled version of > Loader.xls -- I get the following error when going to menu option > "Add-Ins > --> QuantLibXL -> Load -> Fixed Income" using my compiled addin: > > QuantLibXL Error > Error activating addin menu: > Object variable or With block variable not set > > Looks like something in the FixedIncome.xla vba code called upon > loading. Happy to help. It looks as though the Framework configuration has become corrupted. I suggest you first go back to a clean install and confirm that QuantLibXL -> Load -> Fixed Income works as expected. Then make one minimal change, e.g. drop in your new XLL and make the corresponding edit in Loader.xls. If you still get that VBA error you could then hit Ctrl-Break to debug it but I would hope it doesn't come to that. Kind Regards, Eric -- =================================================== Eric Ehlers nazcatech sprl | Brussels | http://www.nazcatech.be * Distributed computing for pricing analytics * Use Microsoft Excel as a client to the Grid ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ QuantLib-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/quantlib-users |
«
Return to quantlib-users
|
1 view|%1 views
| Free forum by Nabble | Edit this page |