quantlib-dev

[Quantlib-dev] QuantLibXL problem under MS Office 2007

[Dominick S. <djs...@ea...>]

Hello,

When I install QuantLibXL-0.8.0 under Office 2007 the associated
drop-down menu does not appear, though a few functions that I tested
seem to work.

Under Office 2007 the menus created by VBA normally appear under
the Add-Ins tab, and this happens with a few programs that I tested, but
it does not seem to work with QuantLibXL. On the other hand, the
QuantLibXL menu appears under Office 2000, for example.

Any ideas?

Thanks,
Dominick

Re: [Quantlib-dev] QuantLibXL problem under MS Office 2007

[Toyin A. <toy...@ho...>]

Hi Dominick,

It works for me.

I installed it a couple of days ago.
I just load Excel 2007 first and then double click on the main addin (or 
drag it onto Excel's surface).

I like it a lot...

Toy out.

>From: Dominick Samperi <djs...@ea...>
>To: qua...@li...,QuantLib developers 
><qua...@li...>
>Subject: [Quantlib-dev] QuantLibXL problem under MS Office 2007
>Date: Thu, 26 Jul 2007 19:19:03 -0400
>
>Hello,
>
>When I install QuantLibXL-0.8.0 under Office 2007 the associated
>drop-down menu does not appear, though a few functions that I tested
>seem to work.
>
>Under Office 2007 the menus created by VBA normally appear under
>the Add-Ins tab, and this happens with a few programs that I tested, but
>it does not seem to work with QuantLibXL. On the other hand, the
>QuantLibXL menu appears under Office 2000, for example.
>
>Any ideas?
>
>Thanks,
>Dominick
>
>-------------------------------------------------------------------------
>This SF.net email is sponsored by: Splunk Inc.
>Still grepping through log files to find problems?  Stop.
>Now Search log events and configuration files using AJAX and a browser.
>Download your FREE copy of Splunk now >>  http://get.splunk.com/
>_______________________________________________
>QuantLib-dev mailing list
>Qua...@li...
>https://lists.sourceforge.net/lists/listinfo/quantlib-dev

_________________________________________________________________
The next generation of Hotmail is here!  http://www.newhotmail.co.uk

Re: [Quantlib-dev] QuantLibXL problem under MS Office 2007

[eric e. <eri...@gm...>]

Hi Dominick,

On 7/27/07, Dominick Samperi <djs...@ea...> wrote:
> Hello,
>
> When I install QuantLibXL-0.8.0 under Office 2007 the associated
> drop-down menu does not appear, though a few functions that I tested
> seem to work.

Have you enabled the setting "Trust access to the VBA project object model"?

This is found under Excel Options, Trust Center, Trust Center
Settings, Macro Settings.

Thanks,
Eric

Re: [Quantlib-dev] QuantLibXL problem under MS Office 2007

[Dominick S. <djs...@ea...>]

Eric,

When I open the ControlPanel spreadsheet first I see the menu. I
incorrectly assumed that the menu would appear if I simply opened
one of the other demo worksheets (like Swap.xls).

Thanks,
Dominick

eric ehlers wrote:
> Hi Dominick,
>
> On 7/27/07, Dominick Samperi <djs...@ea...> wrote:
>   
>> Hello,
>>
>> When I install QuantLibXL-0.8.0 under Office 2007 the associated
>> drop-down menu does not appear, though a few functions that I tested
>> seem to work.
>>     
>
> Have you enabled the setting "Trust access to the VBA project object model"?
>
> This is found under Excel Options, Trust Center, Trust Center
> Settings, Macro Settings.
>
> Thanks,
> Eric
>   

Re: [Quantlib-dev] QuantLibXL problem under MS Office 2007

[eric e. <eri...@gm...>]

Hi Dominick,

On 7/30/07, Dominick Samperi <djs...@ea...> wrote:
> Eric,
>
> When I open the ControlPanel spreadsheet first I see the menu. I
> incorrectly assumed that the menu would appear if I simply opened
> one of the other demo worksheets (like Swap.xls).

Glad to hear that it's working.  ControlPanel.xls was saved with a
reference to QuantLibXL.xla so opening the former causes the latter to
be loaded.  The most straightforward way to start the framework, as
Toyin pointed out, is to open QuantLibXL.xla directly, please see
http://www.quantlibxl.org/framework.html.

Regards,
Eric