Automate an Excel Add-In Install

[TW Bake]

I am looking for a way to install an Add-In from Excel without using
one of the professional install build applications. I'd like for the
user to to be able to open a workbook (or double click) that has an
install button located on a Menu tab. Once pressed, the VBA would then
install the appropriate Add-In(s). Any one have any code that will do
this? How about the add-in itself, if double-clicked (opened) can it
install itself as an add-in?

I've searched for some code, but it looks like most are using the
install-wise type software.

Regards,

TWB

 

[Ron de Bruin]

Hi TW Bake

JKP use something like that in the Name Manager I believe
Check out the code in the install workbook
http://www.jkp-ads.com/officemarketplacenm-en.asp

 

[Charles Chickering]

You can do this with visual basic scripting as well. Open notepad, then paste
this code:
Set oXL = CreateObject("Excel.Application")
oXL.Workbooks.Add
Set oAddin = oXL.Addins.Add("C:\Hide_Columns_Addin.xla", True)
oAddin.Installed = True
oXL.Quit
Set oAddin = Nothing
Set oXL = Nothing

(Change the filename as needed)
Save the notepad file as something.vbs
Double-Click the .vbs file