Dear All,

How can I batch rename *.xlsm files sequentially with same file name in a serial numbers. e.g. Sales Reports1.xlsm,Sales Report2.xlsm......so on.....The files on the folders are Outlook generated Rapid FileNames e.g. 200120207_412809625.xlsm.
I don't want to copy the Files first to the excel then Rename from Column B2.
Instead my B2:B100 has names Sales Reports Jul 1, Sales Reports Jul 2.........100, I would like to rename those inside the Folders on my Desktop. directly.

Thanks & Regards