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?

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)


"Dan" wrote in message
...
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?

Thanks a lot

"Chip Pearson" wrote:

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)


"Dan" wrote in message
...
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?