opening multiple xls files in a folder

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to code it in macro? 2
loop thru folder looking for files with date code in name 7
Sub to open n close .xls files in folders 5
Opening .xls files 2
Command line used for opening .xls files and clicking abutton/running a function. 1
Converted xlsx file to xls. New xls file isn't right, try to correct, fails compat checker 0
Opening Text Files Through Notebook 1
Open .xlsx files in Excel 2002 2

Top