EDITING FILENAMES IN MULTIPLE FOLDERS
Hi
I have a number of files in alphabetical order in several folders. The number of files in each folder can vary over time.
I need to prefix each filename in each folder with a number to number-order all the files in the folder
e.g.
filename1.docx becomes 01_filename1.docx
filename2.docx becomes 02_filename2.docx
filename3.pdf becomes 03_filename3.pdf
and so on. However if in FOLDER1 there are 30 files, then FOLDER2 needs to begin with file31.docx becoming 31_file31.docx and so on. I have 7 Folders.
Is this possible using vba? Thanks in advance for any help.