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

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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>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
>

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
>
>