Hi
I am looking for a macro which will open all files from specified folder and rename files which is just extension to the existing file name.
Example-
If file name is GRIR report – It should be changed as “GRIR report as of 01312018”
If file name is AR aging report – It should be...