create a folder and copy the documents that are in a folder - VBA

[jevi]

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,

 

[jevi]

I thought the same John but maybe the title had a lot on common. I couldn't even reply to tell that was not my intention to do a duplicate.

It worked great...so happy to know this solution as I need to use very often this one.


Thank you so muchhhhhhhhhhh John