Automate an Excel Add-In Install
 

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

Automate an Excel Add-In Install
 

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"TW Bake" wrote in message ups.com...
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

Automate an Excel Add-In Install
 

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

--
Charles Chickering

"A good example is twice the value of good advice."


"TW Bake" wrote:

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