Load xll programatically

For discussion of the xlw project for producing xlls.

Load xll programatically

Postby krad23 » Fri Nov 14, 2014 1:22 pm

I can build an xll successfully using XLW. But then I have to open excel, double click on the xll to load, or go to dev/addins and load it there. This approach would not be suitable for my users.
How can I load it programmatically so that I open Excel and the addin is already loaded?
krad23
 
Posts: 6
Joined: Thu Oct 09, 2014 1:33 pm

Re: Load xll programatically

Postby mj » Mon Nov 24, 2014 10:04 am

you can specify a start up directory where all EXCEL files are automatically loaded every time EXCEL is launched,
mj
Site Admin
 
Posts: 1380
Joined: Fri Jul 27, 2007 7:21 am

Re: Load xll programatically

Postby krad23 » Mon Nov 24, 2014 11:15 am

So here's the solution I found, for anyone else that might need it:

There is a folder
Code: Select all
C:\Users\<user>\AppData\Roaming\Microsoft\AddIns
where if you add the xlls, they show up in Excel in the addins list, but they are not activated.

To get an xll into Excel from any folder and already activated, you need to create a registry key in
Code: Select all
HKEY_CURRENT_USER\Software\Microsoft\Office\#.#\Excel\Options
. Every active addin should have a reg key named OPEN, OPEN1, OPEN2.. and the path to the addin as the value.
krad23
 
Posts: 6
Joined: Thu Oct 09, 2014 1:33 pm


Return to xlw

Who is online

Users browsing this forum: No registered users and 1 guest

cron