Winston618
Member
I have a folder with multiple subfolders. Each subfolder contains a number of files (Xls). The files are downloaded from the company portal. The file names are comprised by the report code (first 10 characters) and followed with date and time. (BCAR022_A_20161206_162511350) Each workbook has just 1 worksheet.
What I need is a macro which first asks me for the target folder, then open each workbook, extract 8 characters from the right (excluding "/") from cell A6, put these character on the right while preserving the first 10 characters of the original file name. Close the file, repeat until the last file. Example: BCAR022_A_20161206_162511350.xls >>> BCAR022_A_20150101.xls
Right now I do all the above manually. The downloading of the workbooks itself is time-consuming and the renaming process takes up a lot of time.
Any help will be appreciated.
What I need is a macro which first asks me for the target folder, then open each workbook, extract 8 characters from the right (excluding "/") from cell A6, put these character on the right while preserving the first 10 characters of the original file name. Close the file, repeat until the last file. Example: BCAR022_A_20161206_162511350.xls >>> BCAR022_A_20150101.xls
Right now I do all the above manually. The downloading of the workbooks itself is time-consuming and the renaming process takes up a lot of time.
Any help will be appreciated.