AddIns
(1)
Application.AddIns
(1)
Macro
(1)
VBA
(1)
AddinUnInstall
(1)
AddinInstall
(1)
TrySub
(1)
Toolpak
(1)

Macro to open and close addins

Asked By Steph
29-Jan-10 03:40 AM
Can anyone provide an example of a macro that loads and / or unloads an
add-in file when run?  For example, if it loads the add-in I would want to
see the file appear in the add-ins available dialog box.  When it unloads the
add-in, it would then be removed from the dialog box.  Thanks for your help.
--
Steph

TrySub AddinInstall()If Not Application.AddIns("Analysis Toolpak - VBA").

Jacob Skaria replied to Steph
29-Jan-10 04:12 AM
Try

Sub AddinInstall()
If Not Application.AddIns("Analysis Toolpak - VBA").Installed Then _
Application.AddIns("Analysis Toolpak - VBA").Installed = True
End Sub

Sub AddinUnInstall()
If Application.AddIns("Analysis Toolpak - VBA").Installed Then _
Application.AddIns("Analysis Toolpak - VBA").Installed = False
End Sub


--
Jacob

Thank you!!--Steph"Jacob Skaria" wrote:

Steph replied to Jacob Skaria
29-Jan-10 06:07 PM
Thank you!!
--
Steph
Post Question To EggHeadCafe