I have been searching for a way to rename 150 files daily simply by executing 1 command.
The current files are in the same folder C:\reports. The file names differ and the only change I have to make is replace yesterday's date and replace it with today's date except on Monday, replace Friday's date to Monday.
Example -
File 1 - Batch030315.xlsx
File 2 - Input030315.xlsx
Tomorrow, the file name would be Batch030415.xlsx & Input030415.xlsx.
Any help anyone can offer would be greatly appreciated.
Thanks
No comments:
Post a Comment