Developer Forum

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://www.yqcomputer.com/ ://support.microsoft.com:80/support/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

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

--
Looking for a good book on programming Exchange, Outlook, ADSI and
SharePoint? Check out http://www.yqcomputer.com/

Thanks

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