COM add-ins

[Robert Flanagan]

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

Bob

 

[Chip Pearson]

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

 

[Mike H]

Hi,

Try this

Sub List_Addins()
Dim x As Long
x = 1
For Each Wb In Application.AddIns
Cells(x, 1) = Wb.Name
x = x + 1
Next Wb
End Sub

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Chip Pearson]

That lists XLA and XLL add-ins, not COM add-ins.

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

 

[Robert Flanagan]

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

 

[Peter T]

You can see and control these Com Addins in the UI -
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins

but not these common to all users
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins

Regards,
Peter T

 

[Chip Pearson]

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