![]() |
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? |
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? |
All times are GMT +1. The time now is 05:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com