Excel add-ins does not show up in Excel>Tools>Add-ins list.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Emmanuel - 18 Nov 2004 18:51 GMT

Hi everybody,

I am trying to create an add-ins for Microsoft Excel using C#.

I started with Microsoft's article 302901 - How To Build an Office COM
Add-in by Using Visual C# .NET
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/s
upport/kb/articles/q302/9/01.asp&NoWebContent=1

The sample and documentation are nice to start with, but I cannot manage to
have exactly the behaviour I want.

The sample add-ins automatically loads when I start the Excel application.

This is done by setting the registry value
HKLM\Software\Microsoft\Office\Excel\AddIns\XXXAddIns.Connect\LoadBehaviour
to 3 which is a combination of 1=Connected and 2=Bootload, as the
documentation states.

What if I want my add-ins to show-up in Tools>Add-Ins and be loaded when the
user selects it (just like "Analysis ToolPak", "Solver Add-In", "Lookup
Wizard" etc ?

Any help would be appreciated.

Thank you

Emmanuel

Reply to this Message

Tom Rizzo [MSFT] - 21 Nov 2004 19:33 GMT

Put it under HKCU rather than HKLM and there is a setting for load on demand
rather than load on startup (I can't remember the DWORD value right now).
You may want to pop over to the
microsoft.public.office.developer.com.add_ins newsgroup as well.

Tom

Signature

Looking for a good book on programming Exchange, Outlook, ADSI and
SharePoint? Check out http://www.microsoft.com/MSPress/books/5517.asp

> Hi everybody,
>
[quoted text clipped - 23 lines]
>
> Emmanuel

Reply to this Message

Emmanuel - 22 Nov 2004 11:41 GMT

Thanks

> Put it under HKCU rather than HKLM and there is a setting for load on
> demand rather than load on startup (I can't remember the DWORD value right
[quoted text clipped - 31 lines]
>>
>> Emmanuel

Reply to this Message

Fariq_Merchant - 22 Dec 2004 01:47 GMT

The DWord value is 8. It did not work for me.

The Addin does not show in the Addin page until the entry in Add-In Manager
key is updated. After that, when add in selected (Checked), the addin is not
loaded. I have put a small message box in OnConnection

System.Windows.Forms.MessageBox.Show("Addin Connect", "MyCOMAddin");

The addin is not disabled as well when it is unchecked. To see this set the
dword value for LoadBeahvior to 3 (Load on starting the application and
connection is established). Unckeck the addin from Tools->Addins. Ihave put
the same message box in public void OnDisconnection, OnBeginShutdown and
OnAddInsUpdate. Need help, please..

Fariq

> Put it under HKCU rather than HKLM and there is a setting for load on demand
> rather than load on startup (I can't remember the DWORD value right now).
[quoted text clipped - 30 lines]
> >
> > Emmanuel

Reply to this Message

Excel add-ins does not show up in Excel>Tools>Add-ins list.

Free Magazines