Prev: Make a file save and close itself based on the value of a cell
Next: Run macro on selected sheets
From: Peter T on 6 Apr 2010 09:36
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

"Robert Flanagan" <nospam(a)nospam.net> wrote in message
news:uSjNf7R1KHA.5972(a)TK2MSFTNGP06.phx.gbl...
> 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
>>>
>
>


From: Chip Pearson on 6 Apr 2010 10:04
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"
<nospam(a)nospam.net> 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" <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
>>>
>
First  |  Prev  | 
Pages: 1 2
Prev: Make a file save and close itself based on the value of a cell
Next: Run macro on selected sheets