WG: VC++2008 / Excel 2003 / QLXL

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

WG: VC++2008 / Excel 2003 / QLXL

petercaspers

interestingly, if I let VC++2008 convert the vc8 project file
"QuantLibXL_full_vc8" to version 9, it works. So, problem solved. (since
the source files are exactly the same, there must be some setting in the
version 9 project file "QuantLibXL_full_vc9", which causes problems?!)

----- Weitergeleitet von Peter Caspers/Controlling und Planung/WGZ BANK/DE
am 17.11.2009 17:00 -----
                                                                           
             Peter                                                        
             Caspers/Controlli                                            
             ng und                                                     An
             Planung/WGZ                [hidden email]
             BANK/DE                    et                                
                                                                     Kopie
             17.11.2009 14:54                                              
                                                                     Thema
                                        VC++2008 / Excel 2003 / QLXL      
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           



Hi, I compile QL / QLXL 0.9.7 with MSVC++2008 (Boost is 1.37.0). There does
not seem to be any problems. However, the resulting XLL can not be loaded
in Excel 2003 (SP3). I get an error message "not a valid XLL". Did anybody
test this configuration? Does an upgrade of any of the components help
perhaps? Thank you, Peter
------------------------------------------------------------------------------------------------------------------------------------------------------
WGZ BANK AG Westdeutsche Genossenschafts-Zentralbank
Sitz: Düsseldorf, Registergericht: Amtsgericht Düsseldorf, HRB 52363
Vorstand: Werner Böhnke (Vors.), Karl-Heinz Moll, Thomas Ullrich,
Hans-Bernd Wolberg
Vorsitzender des Aufsichtsrats: Dieter Philipp

Ueber das Internet versandte E-Mails koennen unter fremdem Namen erstellt
oder inhaltlich veraendert werden. Aus diesem Grund sind unsere als E-Mail
verschickten Nachrichten grundsaetzlich keine rechtsverbindlichen
Erklaerungen. Der Inhalt dieser E-Mail samt Anlagen ist vertraulich und u.
U. rechtlich geschuetzt. Der Inhalt ist ausschließlich an einen bestimmten
Empfaenger gerichtet. Eine Weitergabe, die Herstellung von Kopien oder der
sonstige Gebrauch durch Nichtadressaten ist nicht erlaubt.

Messages sent by e-mail can be manipulated by third parties. For this
reason our e-mail messages are generally not legally binding. This
electronic message (including any attachments) contains confidential
information and may be privileged or otherwise protected from disclosure.
The information is intended to be for the use of the intended addressee
only. Please be aware that any copy, distribution or use of the contents of
this message by any other person than the intended addressee is prohibited.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: WG: VC++2008 / Excel 2003 / QLXL

Nicolai Lassesen
Peter Caspers <peter.caspers <at> wgzbank.de> writes:

>
>
> interestingly, if I let VC++2008 convert the vc8 project file
> "QuantLibXL_full_vc8" to version 9, it works. So, problem solved. (since
> the source files are exactly the same, there must be some setting in the
> version 9 project file "QuantLibXL_full_vc9", which causes problems?!)

I'm using VC++2008 and by trial and error I discovered that telling the linker
to generate a manifest file (/MANIFEST) the xll will work

Nicolai


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: WG: VC++2008 / Excel 2003 / QLXL

petercaspers
I compared the Linker Command Line Strings for both versions. Indeed in the
vc9 project file, no manifest file is generated, in the vc8 file it is
generated.
So, this will be the reason. Perhaps this should be adjusted in one of the
upcoming distributions?
Thank you, best regards
Peter



                                                                           
             Nicolai Lassesen                                              
             <nlassesen@deloit                                            
             te.dk>                                                     An
                                        [hidden email]
             17.11.2009 22:39           et                                
                                                                     Kopie
                                                                           
                                                                     Thema
                                        Re: [Quantlib-users] WG: VC++2008  
                                        / Excel 2003 / QLXL                
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




Peter Caspers <peter.caspers <at> wgzbank.de> writes:

>
>
> interestingly, if I let VC++2008 convert the vc8 project file
> "QuantLibXL_full_vc8" to version 9, it works. So, problem solved. (since
> the source files are exactly the same, there must be some setting in the
> version 9 project file "QuantLibXL_full_vc9", which causes problems?!)

I'm using VC++2008 and by trial and error I discovered that telling the
linker
to generate a manifest file (/MANIFEST) the xll will work

Nicolai


------------------------------------------------------------------------------

Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day

trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users


------------------------------------------------------------------------------------------------------------------------------------------------------
WGZ BANK AG Westdeutsche Genossenschafts-Zentralbank
Sitz: Düsseldorf, Registergericht: Amtsgericht Düsseldorf, HRB 52363
Vorstand: Werner Böhnke (Vors.), Karl-Heinz Moll, Thomas Ullrich,
Hans-Bernd Wolberg
Vorsitzender des Aufsichtsrats: Dieter Philipp

Ueber das Internet versandte E-Mails koennen unter fremdem Namen erstellt
oder inhaltlich veraendert werden. Aus diesem Grund sind unsere als E-Mail
verschickten Nachrichten grundsaetzlich keine rechtsverbindlichen
Erklaerungen. Der Inhalt dieser E-Mail samt Anlagen ist vertraulich und u.
U. rechtlich geschuetzt. Der Inhalt ist ausschließlich an einen bestimmten
Empfaenger gerichtet. Eine Weitergabe, die Herstellung von Kopien oder der
sonstige Gebrauch durch Nichtadressaten ist nicht erlaubt.

Messages sent by e-mail can be manipulated by third parties. For this
reason our e-mail messages are generally not legally binding. This
electronic message (including any attachments) contains confidential
information and may be privileged or otherwise protected from disclosure.
The information is intended to be for the use of the intended addressee
only. Please be aware that any copy, distribution or use of the contents of
this message by any other person than the intended addressee is prohibited.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: WG: VC++2008 / Excel 2003 / QLXL

Eric Ehlers-2
Hi Peter, Hi Nicolai...

Quoting Peter Caspers <[hidden email]>:

> Hi, I compile QL / QLXL 0.9.7 with MSVC++2008 (Boost is 1.37.0). There does
> not seem to be any problems. However, the resulting XLL can not be loaded
> in Excel 2003 (SP3). I get an error message "not a valid XLL". Did anybody
> test this configuration? Does an upgrade of any of the components help
> perhaps? Thank you, Peter

> interestingly, if I let VC++2008 convert the vc8 project file
> "QuantLibXL_full_vc8" to version 9, it works. So, problem solved. (since
> the source files are exactly the same, there must be some setting in the
> version 9 project file "QuantLibXL_full_vc9", which causes problems?!)

Quoting Nicolai Lassesen <[hidden email]>:

> I'm using VC++2008 and by trial and error I discovered that telling  
> the linker
> to generate a manifest file (/MANIFEST) the xll will work

Quoting Peter Caspers <[hidden email]>:

> I compared the Linker Command Line Strings for both versions. Indeed in the
> vc9 project file, no manifest file is generated, in the vc8 file it is
> generated.
> So, this will be the reason. Perhaps this should be adjusted in one of the
> upcoming distributions?
> Thank you, best regards
> Peter

...This is now fixed in the source code repository (svn trunk) for  
inclusion in the next release.

Apologies for the absurdly late response and thanks for the heads up.

Kind Regards,
Eric


------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
Spend less time writing and  rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users