get a list of ticked add-in

D

Dan

Hi,
I am trying to get a list of the selected add-in in an application, I have
tried:

For Each w in aAplication.Workbooks
debug.print w.Name
next w

It does return all the addins in the list - also the non selected (non
ticked).
An I am interested in only the ticked one
Any idea?
 
C

Chip Pearson

Dan,

You can use the "Installed" property to test whether an add-in is loaded
(checked in the list):

Dim AI As Excel.AddIn
For Each AI In Application.AddIns
If AI.Installed = True Then
Debug.Print "Loaded: " & AI.Name, AI.FullName
End If
Next AI


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
D

Dan

Thanks a lot

Chip Pearson said:
Dan,

You can use the "Installed" property to test whether an add-in is loaded
(checked in the list):

Dim AI As Excel.AddIn
For Each AI In Application.AddIns
If AI.Installed = True Then
Debug.Print "Loaded: " & AI.Name, AI.FullName
End If
Next AI


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
Click to expand...
 
Top