Hi,
I am writing a macro that will open a number of workbooks in the same
folder, one at a time. The workbooks will have a uniform naming convention,
like Book1_June_Bob.xls, Book2_June_Tim.xls, etc.

In the macro I want to loop through the folder, looking for a workbook where
the LEFT(FileName,5)=€�Book1.€� When I find €œBook1€�, I want to open it, do some
stuff, close it and then look for €œBook2.€�

Is there code that will do that?





--
Ken Hudson