Jubinell
11-29-2007, 12:48 PM
Hi everybody,
My task is as follows:
================
Given a parent directory, I have to go through each sub-directory within it. At each sub-directory, I have to find all of the .xls files and rename them as follows:
[directory_name]_[original_filename]_e.xls
At the same time, I have to find all .xml files and do the same thing but without the _e suffix.
Finally, I have to record my activities in a spreadsheet. This includes the original and final filenames, and where the files are located.
================
I guess my difficulty lies in the first 2 steps. I don't know if VBA is the right approach. The only windows-related function that I know in VBA is the Dir() function.
Any help is greatly appreciated.
My task is as follows:
================
Given a parent directory, I have to go through each sub-directory within it. At each sub-directory, I have to find all of the .xls files and rename them as follows:
[directory_name]_[original_filename]_e.xls
At the same time, I have to find all .xml files and do the same thing but without the _e suffix.
Finally, I have to record my activities in a spreadsheet. This includes the original and final filenames, and where the files are located.
================
I guess my difficulty lies in the first 2 steps. I don't know if VBA is the right approach. The only windows-related function that I know in VBA is the Dir() function.
Any help is greatly appreciated.