Most addins that are not self written are password protected, so you would
not be able to access the components anyway.
Addins are not designed for this access in the Object model and AFAIK not
accessible., although I could well be wrong..

NickHK

"pinkfloydfan" wrote in message
ups.com...
Actually, that still leaves me with a problem

I want to be able to cycle through the VBComponents in each addin. If
I was looking at a Workbook then I would use:

For Each mybook In Application.Workbooks
For Each vbcomp In mybook.VBProject.VBComponents


But I can't see a way to access the VBProject property from the Addins
collection

Any ideas?

Thanks a lot
Lloyd