Hi all, wish you an early Happy New Year!
I am new to using VBA, looking for help to create a macro that can copy some specific .csv files from subfolders (there are subfolders within subfolders, below is the path I need to copy the files from) to a new folder.
Path: ..../A/B/C/D
A: multiple folders in this level, I need to loop through all
B: multiple folders in this level, I need to loop through all
C: multiple folder in this level but I only need to go into 1, so C is fixed
D: all the .csv files within C that I want to copy to a new folder on desktop
***Also, before I copy any .csv files to the new folder, I want to change its name from "D" to "A - B - D"***
Your help would be greatly appreciated! Thanks!
Bookmarks