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" wrote in message
ups.com...
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" 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