get a list of ticked add-in

[Guest]

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?

 

[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)

 

[Guest]

Thanks a lot

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)