Hi-

I have a folder with 500 or so Excel files and they all start with a
specific date. For Example: 20070119_File1.xls

Does anyone have a macro that will loop through the folder and rename
just the date portion of the file? Example: I want to rename all of
the files that start with 20070119 to start with 20061231 but still
contain the rest of the filename.

Take:

20070119_File1.xls

and rename it:

20061231_File1.xls

Any help is appreciated!

Thanks,
Chris