Copy workbook for every day of the year - 365 days

Hello, I'm not sure this is a basic question... I have to copy a workbook for each day of the year 365 times. The date also has to be in the first cell of the workbook. I have done it manually for the month of January. Is there a way to automate this?

I attached two workbooks to just show the date changes and maybe give an idea of what I'm trying to do without manually having to do this for every day of the year.

thanks for your help.

How about this?


Place in standard module of one of the workbooks, change saveas path and run.
You'll be left with the last workbook open.

Please Login or Register  to view this content.

Thank you.

thank you! Can you help me with changing the path?

Hi,
Just change the red part to the path of the folder where you're saving them.

Please Login or Register  to view this content.

Thank you so much! Worked perfectly