I am using excel 2002. I want to select a folder and open the first xls file
then search the first sheet for some text, close that file then open the next
file search it, then the next file search it and so on. I cant figure out
how to open the first file close it, open the next file close it and so on
until I have done this with all the xls files in a particular folder. Any
help would be much appreciated.