| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
repeating code on files in multiple subfolders
I would like to run program on every file in a folder. I have code that
accomplishies this if the folder contains the files directly. However, I need to do this on files that are in subfolders. The filesin sub folder A are named the same as those in B, C, etc. So I can not simply copy them all to the main folder. Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
repeating code on files in multiple subfolders
Try FSO
http://www.rondebruin.nl/fso.htm This example copy a range but you can adapt it to run your code instead of the copy/paste action -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ED007" wrote in message ... I would like to run program on every file in a folder. I have code that accomplishies this if the folder contains the files directly. However, I need to do this on files that are in subfolders. The filesin sub folder A are named the same as those in B, C, etc. So I can not simply copy them all to the main folder. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening files in folders and subfolders | Excel Discussion (Misc queries) | |||
| Open all files in subfolders | Excel Programming | |||
| replace text in files within subfolders | Excel Programming | |||
| copy subfolders, replace text in files and save files in copied subfolders | Excel Programming | |||
| Modify - look at files within subfolders | Excel Programming | |||
Linear Mode
