Excel Add-ins

[ClulessChris]

I’ve recently got into using Excel add-ins (*.xla) but would like to learn more about, programmatically adding / removing them.
Were they’re stored (I notice they copy themselves to C: when added).

And best practice for updating a distributed add-in. would this be best achieved by a coded worksheet, separate VBS file, or maybe a batch file?

Can you suggest any good resources on these issues? Google seems to show plenty of guidance on how to build and install an Add-in, but this is not quite what I’m looking for.

Many thanks in advance.


Everybody body is somebodys Nutter.

 

[JensKKK]

Better late than never ->>>>>

This code will open a add-in in your program. Replace the solver with your add-in name and it should work.



Application.Run "Solver.xla!Autpen"

Hope that helps.

 

[combo]

Have you tried the installation method I pointed in your later post? The natural way add-in works is rather installing it than opening manually or by code.

combo

 

[ClulessChris]

Both thanks for the input.
Combo, I've not tried the method you posted as I belive it involves a third party application, and I'd like to find a solution that doesn't involve 3rd party. However I'm holding that in reserve should I fail.

regards

Everybody body is somebodys Nutter.

 

[combo]

As far as I remember, it uses free creator of installation package - it is on your side. Next unpacked excel file is used to install 'xla' add-in that finally (on first open) removes the support file.

combo