none
Programmatic Removal of Excel Addin RRS feed

  • Question

  • Does anybody know how to programmatically remove an installed Excel Addin. I need to do this so that I can issue updates to the addIn code to users in such a way as to avoid the messy procedure that is involved in using the AddIns manager.

    I am trying to do this through code in an Installations workbook which would execute when the users opened this workbook.

    Thanks in Advance

    Dennis Jelavic

    Monday, April 29, 2013 7:24 AM

Answers

  • Try below code. It would remove all addin installed.

    Sub sample()
        Dim objAddin As AddIn
        For Each objAddin In AddIns
            If objAddin.Installed = True Then
                 Debug.Print objAddin.Name & " " & objAddin.Installed
                objAddin.Installed = False
            End If
        Next
    End Sub
    

    • Proposed as answer by Shasur Monday, April 29, 2013 10:03 AM
    • Marked as answer by CatFelix Monday, April 29, 2013 7:49 PM
    Monday, April 29, 2013 8:08 AM
  • Thanks for the response. It overcame my problem. I'll have to learn to look at my own code more closely before posting.

    Dennis Jelavic

    • Marked as answer by CatFelix Monday, April 29, 2013 7:50 PM
    Monday, April 29, 2013 7:49 PM

All replies

  • Try below code. It would remove all addin installed.

    Sub sample()
        Dim objAddin As AddIn
        For Each objAddin In AddIns
            If objAddin.Installed = True Then
                 Debug.Print objAddin.Name & " " & objAddin.Installed
                objAddin.Installed = False
            End If
        Next
    End Sub
    

    • Proposed as answer by Shasur Monday, April 29, 2013 10:03 AM
    • Marked as answer by CatFelix Monday, April 29, 2013 7:49 PM
    Monday, April 29, 2013 8:08 AM
  • I use an Addin Loader to solve this kind of problem:

    you can download and customise mine from

    http://www.decisionmodels.com/downloads.htm


    Charles Excel MVP The Excel Calculation Site http://www.decisionmodels.com/

    Monday, April 29, 2013 12:34 PM
  • Thanks for the response. It overcame my problem. I'll have to learn to look at my own code more closely before posting.

    Dennis Jelavic

    • Marked as answer by CatFelix Monday, April 29, 2013 7:50 PM
    Monday, April 29, 2013 7:49 PM