QuantLibXL not working with Excel 2007 ?

[Kim Kuen Tang]

Hi all,

QuantLibXL compiled successfully with MSVC 2008  and boost  1.40.
But the addin cannot be loaded by Excel 2007.  It gives the error
message R6043 Runtime Error.

Did anybody succesfully load the addin in EXCEl 2007?


Best regards,
Kim Tang

------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev

[Ferdinando Ametrano-4]

On Sun, Sep 27, 2009 at 6:06 PM, Kim Kuen Tang <[hidden email]> wrote:
> QuantLibXL compiled successfully with MSVC 2008  and boost  1.40.

how did you manage to compile it with boost 1.40 ?
The current QLXL trunk cannot be compiled with boost 1.40 as there are
errors in the boost header files

ciao -- Nando

--
RSS feed: http://www.google.com/reader/shared/ferdinando.ametrano

------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev

[Kim Kuen Tang]

Hi Ferdinando,

i dont know which errors you are talking about, since i dont get them.
The problem with the preprocessor BOOST_HAS_LONG_LONG is for example
fixed in the trunk version.
See the log message:

Revision: 51503
Author: bemandawes
Date: 15:14:09, Sonntag, 1. März 2009
Message:
config: fix both BOOST_HAS_LONG_LONG and BOOST_NO_LONG_LONG getting
defined at the same time for some compilers
----
Modified : /trunk/boost/config/suffix.hpp



However using the latest boost library from trunk version i managed to
compile quantlib together with QLXL. The problem is that the produced
addin cannot be loaded by Excel 2007.

Best regrards,
Kim

Ferdinando Ametrano schrieb:

> On Sun, Sep 27, 2009 at 6:06 PM, Kim Kuen Tang <[hidden email]> wrote:
>  
>> QuantLibXL compiled successfully with MSVC 2008  and boost  1.40.
>>    
>
> how did you manage to compile it with boost 1.40 ?
> The current QLXL trunk cannot be compiled with boost 1.40 as there are
> errors in the boost header files
>
> ciao -- Nando
>
> --
> RSS feed: http://www.google.com/reader/shared/ferdinando.ametrano
>
>  

------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev

[Kim Kuen Tang]

Hi all,

some more tests show that the combination QuantLib 0.9.7, QuantLibXL
0.9.7 und boost 1.41 compiles fine. The produced addin can also be
loaded by Excel 2007 if the whole Solution QuantLibXL_full_vc9 is
compiled under static (runtime) mode.

Is there a reason for that?

Best regards,
Kim

Ferdinando Ametrano schrieb:

> On Sun, Sep 27, 2009 at 6:06 PM, Kim Kuen Tang <[hidden email]> wrote:
>  
>> QuantLibXL compiled successfully with MSVC 2008  and boost  1.40.
>>    
>
> how did you manage to compile it with boost 1.40 ?
> The current QLXL trunk cannot be compiled with boost 1.40 as there are
> errors in the boost header files
>
> ciao -- Nando
>
> --
> RSS feed: http://www.google.com/reader/shared/ferdinando.ametrano
>
>  

------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev

[Ferdinando Ametrano-4]

Hi Kim

On Thu, Oct 1, 2009 at 6:40 AM, Kim Kuen Tang <[hidden email]> wrote:
> some more tests show that the combination QuantLib 0.9.7, QuantLibXL
> 0.9.7 und boost 1.41 compiles fine. The produced addin can also be
> loaded by Excel 2007 if the whole Solution QuantLibXL_full_vc9 is
> compiled under static (runtime) mode.
>
> Is there a reason for that?

I personally don't use the boost trunk, official releases only.

When boost 1.40 has been released I checked and the QuantLib trunk did
not compile; there was QLXL code triggering error in boost header
files. For me it was the end of the story as I don't want to patch
boost and I'm willing to wait for 1.41, using 1.39 in the meantime

As for Excel 2007 I don't have acces to it as I still use Excel 2002
at work and Excel 2003 at home.

ciao -- Nando

--
RSS feed: http://www.google.com/reader/shared/ferdinando.ametrano

------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev