--
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
| > |
| > |
| >
| >
|
|
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.