Listing installed COM add-ins

[Bob Flanagan]

Is there a way to list via vba the COM add-ins that are installed as
auto-opening add-ins?

Bob

 

[Jim Rech]

Enumerate the add-ins listed under
HKCU\Software\Microsoft\Office\Excel\Addins maybe?

--
Jim
| Is there a way to list via vba the COM add-ins that are installed as
| auto-opening add-ins?
|
| Bob
|
|

 

[Peter T]

also -

Dim cai As COMAddIn
For Each cai In Application.COMAddIns
Debug.Print cai.Connect, cai.ProgId, cai.Description
Next

Doesn't of course fully confirm the auto-opening state (ConnectMode), but
as-good-as if you run in the open event of an installed xla.

Regards
Peter T

 

[Jim Rech]

WAY better!

--
Jim
| also -
|
| Dim cai As COMAddIn
| For Each cai In Application.COMAddIns
| Debug.Print cai.Connect, cai.ProgId, cai.Description
| Next
|
| Doesn't of course fully confirm the auto-opening state (ConnectMode), but
| as-good-as if you run in the open event of an installed xla.
|
| Regards
| Peter T
|
| | > Enumerate the add-ins listed under
| > HKCU\Software\Microsoft\Office\Excel\Addins maybe?
| >
| > --
| > Jim
| > | > | Is there a way to list via vba the COM add-ins that are installed as
| > | auto-opening add-ins?
| > |
| > | Bob
| > |
| > |
| >
| >
|
|

 

[Jim Cone]

Hi Peter,
Did you finally trade in xl97_sr1 for xl2003? <g>
Regards,
Jim Cone


"Peter T"
<peter_t@discussions>
wrote in message
also -
Dim cai As COMAddIn
For Each cai In Application.COMAddIns
Debug.Print cai.Connect, cai.ProgId, cai.Description
Next
Doesn't of course fully confirm the auto-opening state (ConnectMode), but
as-good-as if you run in the open event of an installed xla.
Regards
Peter T

 

[Peter T]

LOL!
Now why would I want to trade in my trusty xl97_sr1 !
But as I write dll's, which can also run as ComAddins, I need at least
xl2000 as well.

Regards,
Peter T