Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
try to install a security update, prompted to install PRO11.msi | Setting up and Configuration of Excel | |||
How to install Excel Add-Ins without a CD? | Excel Worksheet Functions | |||
Is there a way to install Excel if I use XP? | Excel Programming | |||
What program do I install to install office 2003 with no prior pro | Excel Discussion (Misc queries) | |||
Why does PHStats *NOT* install when I install Analytical ToolPak? | Setting up and Configuration of Excel |