Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default folder for opening/saving files | Excel Discussion (Misc queries) | |||
opening order macro for files in a folder | Excel Programming | |||
"Folder Select" Dialogue - Opening multiple files from selected folder | Excel Programming | |||
Opening Files from a folder in sorted order. | Excel Programming | |||
Opening all txt files in a folder and saving as excel | Excel Programming |