opening multiple xls files in a folder
 

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.

opening multiple xls files in a folder
 

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.