Prev: Make a file save and close itself based on the value of a cell
Next: Run macro on selected sheets
From: Robert Flanagan on 5 Apr 2010 09:39
Is there a way via vba code to list the COM add-ins running in Excel?

Bob


From: Chip Pearson on 5 Apr 2010 10:45
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"
<nospam(a)nospam.net> wrote:

>Is there a way via vba code to list the COM add-ins running in Excel?
>
>Bob
>
From: Mike H on 5 Apr 2010 11:14
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.


"Robert Flanagan" wrote:

> Is there a way via vba code to list the COM add-ins running in Excel?
>
> Bob
>
>
> .
>
From: Chip Pearson on 5 Apr 2010 11:47
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


On Mon, 5 Apr 2010 08:14:01 -0700, Mike H
<MikeH(a)discussions.microsoft.com> wrote:

>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
From: Robert Flanagan on 5 Apr 2010 20:19
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" <chip(a)cpearson.com> wrote in message
news:lntjr51hkvu914dnsta4de0nfgfbijqsd8(a)4ax.com...
> 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"
> <nospam(a)nospam.net> wrote:
>
>>Is there a way via vba code to list the COM add-ins running in Excel?
>>
>>Bob
>>


 |  Next  |  Last
Pages: 1 2
Prev: Make a file save and close itself based on the value of a cell
Next: Run macro on selected sheets