I am new to VBA and I would like to know how I can loop through folders to select files starting with a certain word and copy all of them to a different folder and rename them. The folder structure is given below
Company 1(parent folder)
North South East(sub folder) West(sub folder)
Jan Feb Mar.... Dec Jan Feb Mar.... Dec Jan Feb Mar.... Dec Jan Feb Mar.... Dec
In the above structure, the files are present inside each folders Jan, feb...Dec under the regions North, South East n west. Please note that I have to select files starting with "Sales" and copy them into a new folder(say results) and rename copied files as Sales1.xls, Sales2.xls etc Any help would be highly appreciated. (Files are not present in the folder company1, north, south, east and east.)
Please note: I have posted the question here also.
http://www.mrexcel.com/forum/excel-q...ml#post3676482
Bookmarks