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

Bob

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

--
Jim
"Bob Flanagan" wrote in message
. ..
| Is there a way to list via vba the COM add-ins that are installed as
| auto-opening add-ins?
|
| Bob
|
|

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" wrote in message
...
Enumerate the add-ins listed under
HKCU\Software\Microsoft\Office\Excel\Addins maybe?

--
Jim
"Bob Flanagan" wrote in message
. ..
| Is there a way to list via vba the COM add-ins that are installed as
| auto-opening add-ins?
|
| Bob
|
|

WAY better!

--
Jim
"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
|
| "Jim Rech" wrote in message
| ...
| Enumerate the add-ins listed under
| HKCU\Software\Microsoft\Office\Excel\Addins maybe?
|
| --
| Jim
| "Bob Flanagan" wrote in message
| . ..
| | Is there a way to list via vba the COM add-ins that are installed as
| | auto-opening add-ins?
| |
| | Bob
| |
| |
|
|
|
|

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

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


"Jim Cone" wrote in message
...

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