Lloyd,
Use the AddIns collection ?
Check if each is .Installed, if so, do what you need.

NickHK

"pinkfloydfan" wrote in message
oups.com...
Hi there

If you use something like this:

For Each mybook In Application.Workbooks

It will only reference all the open .xls files. According to the help
you can use Application.Workbooks("filename.xla") to access a
single .xla if you know its name but that doesn't help to write
generic code.

Does anyone know of a way to cycle through all the open .xla's without
having to know their names first?

Thanks a lot
Lloyd