Hello,

I have developed an add-in for Excel which exposes the
IDTExtensibility2 interface in order to obtain a reference to Excel
(needed to add menu entries for initialization). Once initialized, the
add-in provides functions to be used as formulae in a worksheet.

My problem is: the OnConnection method in IDTExtensibility2 does not
get called until I edit a formula provided by the add-in.

I have registered the add-in as an automation add-in. If I register it
as a COM add-in (in the registry), functions are not available for use
as worksheet formulae.

Any ideas ?

Lars

What is the load behavior setting? It sounds like it was configured for Load
On Demand.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Lars" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
>
> I have developed an add-in for Excel which exposes the
> IDTExtensibility2 interface in order to obtain a reference to Excel
> (needed to add menu entries for initialization). Once initialized, the
> add-in provides functions to be used as formulae in a worksheet.
>
> My problem is: the OnConnection method in IDTExtensibility2 does not
> get called until I edit a formula provided by the add-in.
>
> I have registered the add-in as an automation add-in. If I register it
> as a COM add-in (in the registry), functions are not available for use
> as worksheet formulae.
>
> Any ideas ?
>
> Lars
>

On Jun 25, 1:24 pm, "Chip Pearson" <c...@cpearson.com> wrote:
> What is the load behavior setting? It sounds like it was configured for Load
> On Demand.

The registry setting for the COM add-in is set to disabled (0). I
assume it is loaded on demand because I register it as an automation
add-in.

If I set LoadBehavior to 3 (startup) in the registry I get the menu
entry at startup and a second instance of the add-in is created when I
start to edit a formula provided by the add-in.

If I do not register the add-in in the list of automation add-ins I
cannot access the formula

Lars