Only COM add-ins that are for the current user (in registry HKCU) are
displayed in the dialog. CAIs that are installed for all users of the
machine (registry HKLM) are not listed in the dialog, but are part of
the COMAddIns object. I believe that the reason for not listing the
all users' CAIs is to prevent one user from changing something that is
used by all users.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com



On Mon, 5 Apr 2010 20:19:42 -0400, "Robert Flanagan"
wrote:

Thanks Chip. I ran the code and it listed two COM add-ins. When I clicked
on the COM Add-ins button one can add to a toolbar, only one of the two are
listed in the dialog. The other is not. What does that mean?

Bob

"Chip Pearson" wrote in message
.. .
Try something like

Dim CAI As Office.COMAddIn
For Each CAI In Application.COMAddIns
If CAI.Connect = True Then
Debug.Print CAI.Description, CAI.progID
End If
Next CAI

This will list both COM Add-Ins that are installed and connected for
the current user (which will be listed in the COM Add-Ins dialog) as
well as CAIs that are loaded for all users (not listed in the CAI
dialog).

If you want a list of all CAIs, not just those currently loaded, get
rid of the If conditional in the code.


Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com




On Mon, 5 Apr 2010 09:39:18 -0400, "Robert Flanagan"
wrote:

Is there a way via vba code to list the COM add-ins running in Excel?

Bob