QuantLibXL problem under MS Office 2007

[Dominick Samperi-2]

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-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[Toyin Akin]

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 <[hidden email]>
>To: [hidden email],QuantLib developers
><[hidden email]>
>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
>[hidden email]
>https://lists.sourceforge.net/lists/listinfo/quantlib-dev

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


-------------------------------------------------------------------------
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-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[eric ehlers]

Hi Dominick,

On 7/27/07, Dominick Samperi <[hidden email]> 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

-------------------------------------------------------------------------
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-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[Dominick Samperi-2]

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 <[hidden email]> 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
>  

-------------------------------------------------------------------------
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-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[eric ehlers]

Hi Dominick,

On 7/30/07, Dominick Samperi <[hidden email]> 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

-------------------------------------------------------------------------
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-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users