« Andrew’s Excel Tips
FillSeries Keyboard Shortcut »

Determine Which COM Add-ins Are Installed

16th July 2008, 03:01 pm by Dick Kusleika

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).

Category: Toolbars, Add-ins  |  Comment (RSS)  |  Trackback

4 Comments

  1. Nick Hebb:

    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).

    16 July 2008, 4:47 pm

  2. Eric W. Bachtal:

    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.

    16 July 2008, 6:31 pm

  3. Miley-Cyrus-Fan:

    hmm.. thank you very much. usefull information

    1 August 2008, 10:48 am

  4. Peter Thornton:

    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)

    5 August 2008, 6:05 am

Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Leave a comment