Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to programmatically remove an AddIn (xla)
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to programmatically remove an AddIn (xla)
Try something like:
Addins("Solver Add-in").Installed = False -- Rob van Gelder - http://www.vangelder.co.nz/excel "AndyB" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove Addin | Excel Discussion (Misc queries) | |||
remove name of addin in Tools menu: "Document Project" | Excel Discussion (Misc queries) | |||
Programmatically remove sharing? | Excel Programming | |||
Remove Excel AddIn from AddIn List !! Help | Excel Programming | |||
Programmatically Add Reference` | Excel Programming |