Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Add-ins

Status
Not open for further replies.

ClulessChris

IS-IT--Management
Jan 27, 2003
890
GB
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.
 
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!Auto_Open"

Hope that helps.
 
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
 
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top