jevi
Active Member
- Joined
- Apr 13, 2010
- Messages
- 339
- Office Version
- 2016
- Platform
- Windows
Hi All,
I have a Report Folder and inside it are some files that I use for everyday reporting and then the folders with the date Today ()-1. I would like a macro then can create the folder with the date Today()-1 from Tuesday to Friday and then on Monday Today ()-3 and copy the files are in the folder Report.
It would be fantastic if all the files that are copied in the new folder for example of today the folder I created is 26.05.2022 have the date at the end of the name of the files...for example if a report is named: Cash when is it copied to the folder of 26.05.2022, to be Cash 26.05.2022
Thank you,
I have a Report Folder and inside it are some files that I use for everyday reporting and then the folders with the date Today ()-1. I would like a macro then can create the folder with the date Today()-1 from Tuesday to Friday and then on Monday Today ()-3 and copy the files are in the folder Report.
It would be fantastic if all the files that are copied in the new folder for example of today the folder I created is 26.05.2022 have the date at the end of the name of the files...for example if a report is named: Cash when is it copied to the folder of 26.05.2022, to be Cash 26.05.2022
Thank you,