Determine Which COM Add-ins Are Installed

The COM Add-in (Component Object Model) toolbar button is not on any toolbars by default. You have to add it and then click on it to get to the COM Add-in dialog. First, right click in a blank area around the toolbars and choose Customize

Go to Tools on the left and COM Addins on the right

Drag it onto an existing toolbar – the I bar tells you where it’s going to go

Now it’s on the toolbar, so click it

And you get this dialog. It shows that I have one COM Add-in that it’s not loaded (unchecked).

Posted in Uncategorized

4 thoughts on “Determine Which COM Add-ins Are Installed

  1. The downside is that this dialog won’t show COM add-ins installed for all users. Microsoft did this so add-ins installed by Admins can’t be removed by limited access users. If you want to see all the COM add-ins installed on your system, there’s a neat little (free) utility from Nirsoft called Officeins (http://www.nirsoft.net/utils/officeins.html).

  2. If you don’t need a permanent toolbar modification, here’s a one-liner for the VBA Immediate window:

    set c = CommandBars(1).Controls.Add(Id:=3754): c.Execute: c.Delete

    Not sure if that Id is good outside of Excel 2003.

  3. In the excel.programming group
    Subject: Listing installed COM add-ins, 13 Feb 08

    Dim cai As COMAddIn
    For Each cai In Application.COMAddIns
    Debug.Print cai.Connect, cai.ProgId, cai.Description
    Next

    Eric’s one liner works in XL2000 (the id is good)

Leave a Reply

Your email address will not be published. Required fields are marked *