This macro uses python/shutil library to rename files to any new name.
This is useful in cases where you receive data with no name patterns, or at least, not the one that you would like to.
INPUT of filepaths to be renamed (example):
FileCurrentName | FileNewName |
Output.xlsx | Output_20220102.xlsx |
SAPExtraction_16cefd9e6da78821d90d713c46f1d056.txt | SAP_20220102.txt |
Report_Qlik_Dashboard.pdf | Report.pdf |