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
|