Replicate excel file into many duplicate files

[hasan mougharbel]

Hey guys,
I hope you are well.
I have an excel template file, through which i want to replicate same file of it.
Can i replicate copies of that template file at once and by assigning every file name as that of the of the respective dates.
So i shall have a file titled 2/12/2022 , 3/12/2022 , 4/12/2022 , 5/12/2022 , and so on.
In other words my purpose is to have files from now till the end of december, and 365 file all for all days in 2023.
All with one click vba program.
Thanks a lot.

Please refer to my excel template file said is to be replicated.

[ByteMarks]

If you open the template file, add this code and run, it'll save a copy of the template for each date in 2023 in the same location.

Please Login or Register  to view this content.