Hi SC,

See Ron de Bruin's sample code at:

http://www.rondebruin.nl/copy3.htm

---
Regards,
Norman



"sc" wrote in message
...
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 can't 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.