How to load xll when opening the excel

Dec 9, 2014 at 3:53 AM
Hi,
I want that the addin gets loaded as soon as i open my excel.Is there any way to load the xll.
In current scenario ,I actually open the xll and then it asks for the loading of dll for current session.

Thanks and Regards
Manoj
Coordinator
Dec 9, 2014 at 8:21 AM
Hi Manoj,

You can go to the Excel Add-ins dialog to add it.
The easiest way to find it is by pressing Alt+t, i.

Otherwise you can go File -> Options -> Add-Ins, then at the bottom of the form: Manage: Excel Add-Ins [Go...]

-Govert
Dec 9, 2014 at 9:15 AM
Sadly, if you start Excel using COM automation (new Excel.Application()) most AddIn types will not get loaded. Then you have to register the .xll manually with application.RegisterXLL.
Coordinator
Dec 9, 2014 at 9:39 AM
Yes, that's correct.

-Govert
Dec 10, 2014 at 4:54 AM
Hi Govert,

Thanks for the reply.

Is there any way to register it programatically while excel startup. By doing the way you said is manually attempt and have to manually setup on each client machine
Coordinator
Dec 10, 2014 at 10:18 AM
I'd suggest you try the COM object model, with something like
dynamic Application = ExcelDnaUtil.Application;
dynamic myAddIn = Application.AddIns.Add(theAddInPath);
myAddIn.Installed = true;
But you'll have to experiment a bit.
Also have a look at the documentation here: https://exceldna.codeplex.com/wikipage?title=Installing%20your%20add-in

-Govert