QuantlibXL 0.3.13 - Excel crashed when accessing from VBA module

[Wilkie Lai]

 Hi,
 I am new to QuantlibXL but based on the posts I have
read and instructions previously given, I have tried
to call QuantLib functions from VBA using
Application.Run() method.  However in version 0.3.13
Excel always crashed when the ql method is called and
I think when ObjectHandler is accessed.  I have
already tried on 2 different Excel versions (both
2002, different lauguages) on different machines, both
crashed in similar way and debug message is pointing
to QuantLibXL-vc80-mt-s-0_3_13.
 Can someone please confirm if this is a known bug
with 0.3.13, or there is a new way to call ql
functions from VBA with 0.3.13?  


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com 

[eric ehlers]

Hello,

On 8/25/06, Wilkie Lai <[hidden email]> wrote:

>
>  Hi,
>  I am new to QuantlibXL but based on the posts I have
> read and instructions previously given, I have tried
> to call QuantLib functions from VBA using
> Application.Run() method.  However in version 0.3.13
> Excel always crashed when the ql method is called and
> I think when ObjectHandler is accessed.  I have
> already tried on 2 different Excel versions (both
> 2002, different lauguages) on different machines, both
> crashed in similar way and debug message is pointing
> to QuantLibXL-vc80-mt-s-0_3_13.
>  Can someone please confirm if this is a known bug
> with 0.3.13, or there is a new way to call ql
> functions from VBA with 0.3.13?

This is not a known bug (at least, not yet known to me :-) ) and there
should be no change to the procedure for calling the addin from VBA.
I'll try to recreate the problem and I'll let you know.

Thanks,
Eric

[eric ehlers]

Hello

On 8/25/06, Wilkie Lai <[hidden email]> wrote:
>  Hi,
>  I am new to QuantlibXL but based on the posts I have
> read and instructions previously given, I have tried
> to call QuantLib functions from VBA using
> Application.Run() method.  However in version 0.3.13
> Excel always crashed when the ql method is called and

1) The crash is caused by a bug in Objecthandler, you need to patch
the bug and rebuild ObjectHandler/QuantLibXL from source.
2) The sample VBA code is changed for QuantLibAddin 0.3.13.

I've documented both of these items in the FAQ:
http://www.quantlibaddin.org/faq.html

Sorry for the inconvenience.

Regards,
Eric