ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   repeating code on files in multiple subfolders (https://www.excelbanter.com/excel-programming/385302-repeating-code-files-multiple-subfolders.html)

ED007

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?

Ron de Bruin

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