this is the basic idea.

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

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
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