vba-tutorial.com
For Each Loop: Workbooks in Application - VBA Tutorial
This codes sample iterates through all the workbooks in an Excel application using a for each loop.