I've figured out how to do the looping from this article:

http://msdn.microsoft.com/en-us/library/ms345182.aspx

It gives me back all tabs and named ranges. The latter is a problem but I will...

Thanks for the reply. I've found several samples showing how to loop through many Excel files but I haven't seen anything good on how to loop through many tabs...