Loop through workbooks and worksheets in each workbook

[eric.fader]

Hi:

I am looking for a code sample that will loop through all excel
workbooks and all of worksheets within each of the workbooks.

Can someone please provide some insight into how to accomplish this?

Thanks,
Eric

 

[Don Guillett]

this is the basic idea.

for each wb in workbooks
for each ws in worksheets
do thing
next ws
next wb