How to programmatically remove an AddIn (xla)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a clean way to programmatically remove an XLA AddIn in Excel? (eg using VBA, modifying the registry etc)

I can load and install the AddIn using VBA using code somehting like this:

If Application.AddIns("MyAddIn") Is Nothing Then
With AddIns.Add("<MyAddInPath>\MyAddIn.xla")
.Installed = True
End With
End If

And I know I can manually remove the entry in the AddIn list by deleting the AddIn .xla file and then seleciting it in the list and answering 'yes' when Excel prompts to remove it, but I would like to automate the uninstall of my app (which includes an Excel AddIn) without requiring the user to do this manually. It appears that there is no 'Remove' method for the AddIns collection.

Any suggestions?

Thanks

AndyB
 
Try something like:
Addins("Solver Add-in").Installed = False


--
Rob van Gelder - http://www.vangelder.co.nz/excel


AndyB said:
Is there a clean way to programmatically remove an XLA AddIn in Excel? (eg
Click to expand...
using VBA, modifying the registry etc)
I can load and install the AddIn using VBA using code somehting like this:

If Application.AddIns("MyAddIn") Is Nothing Then
With AddIns.Add("<MyAddInPath>\MyAddIn.xla")
.Installed = True
End With
End If

And I know I can manually remove the entry in the AddIn list by deleting
Click to expand...
the AddIn .xla file and then seleciting it in the list and answering 'yes'
when Excel prompts to remove it, but I would like to automate the uninstall
of my app (which includes an Excel AddIn) without requiring the user to do
this manually. It appears that there is no 'Remove' method for the AddIns
collection.
 
Back
Top