Posted by
Jerry Jie Ji on
URL: http://quantlib.414.s1.nabble.com/RE-Err-Msg-Not-excel-add-in-format-for-Object-Handler-examples-tp4526.html
Whoa, such detailed answer really warrant its place in an FAQ. While I
crash through the material mentioned, could you please share with us
more on the automation add-in function/technology?
Thanks and regards,
Jerry
-----Original Message-----
From: Sinha, Amitesh [mailto:
[hidden email]]
Sent: Wednesday, March 01, 2006 9:44 AM
To: Jerry Jie Ji
Subject: RE: [Quantlib-users] Err Msg "Not excel add-in format" for
Object Handler examples
If you have excel 2003, why do not you use automation add-in to expose
the functions directory from quantlib library. XLL technology is getting
deprecated. Most of your efforts are likely to be lost in coming years.
Having said that, the following pointers may be of interest to you.
1.
http://www.planatechsolutions.com/xlpfaq/Q0011.htm essentially open your xll in visual studio tool "depends" and
see if any dll xll depends on is missing. I suspect log4cxx , oh dll
may not be in the path. If you do not have depends, go to
www.dependencywalker.com.
2. I am hoping that you are not mixing managed C++ and unmanaged C++ as
string in managed C++ are treating differently. Most likely you are
not doing this.
3. If point 1 does not rescue you, you may be mixing debug/release
libraries, just check that you are not doing this.
4. Using DumpBin /Exports should list the DLLs bound statically to your
code. You need to ensure they are in your
path, and not just lying around the target machine.
If you are familiar with COM, you might want to consider making
automation add-in. xlls are painful and deprecated technology. I just
use C# wrapper of C++ dlls. I even avoid explicit COM programming.
let me know if the problem goes away.
Regards
Amitesh Sinha
Valuation Risk Group
CREDIT SUISSE
Phone: +852-2101-6643
Mobile: +85267737571
email:
[hidden email]
-----Original Message-----
From:
[hidden email]
[mailto:
[hidden email]]On Behalf Of Jerry
Jie Ji
Sent: Wednesday, March 01, 2006 8:57 AM
To:
[hidden email]
Subject: RE: [Quantlib-users] Err Msg "Not excel add-in format" for
ObjectHandler examples
Similar problem here, just that I'm using MS VC++ 2005 Express (8)
and MS Excel (Office) 2003.
Many thanks in advance!
--
Jerry
Singapore
-----Original Message-----
From:
[hidden email]
[mailto:
[hidden email]] On Behalf Of Liu,
Xiaobo
Sent: Wednesday, March 01, 2006 6:43 AM
To:
[hidden email]
Subject: [Quantlib-users] Err Msg "Not excel add-in format" for
ObjectHandler examples
> Hi,
>
> I complied both latest versions of ObjectHandler
> and QuantlibAddin, but could not load up
> any *.xll files due to error msg stating that
> the xll files are NOT of Excel add-in format.
>
> I am using MSVC++ 6.0 and Excel 2000,
and would greatly appreciate any help on this.
> Regards,
> Xiaobo Liu
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
that extends applications into web and mobile media. Attend the live
webcast
and join the prime developer group breaking into this new coding
territory!
<a href="http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642">http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642
_______________________________________________
Quantlib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-usersCONFIDENTIAL NOTE: The information contained in this email is intended
only for the use of the individual or entity named above and may contain
information that is privileged, confidential and exempt from disclosure
under applicable law. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of this communication is strictly prohibited. If you have
received this message in error, please immediately notify the sender and
delete the mail.
Thank you.
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
that extends applications into web and mobile media. Attend the live
webcast
and join the prime developer group breaking into this new coding
territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642_______________________________________________
Quantlib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users========================================================================
======
Please access the attached hyperlink for an important electronic
communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html========================================================================
======
CONFIDENTIAL NOTE: The information contained in this email is intended only for the use of the individual or entity named above and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete the mail.
Thank you.