copy template,past new sheet and rename to given date for 30 days

Try this code in a standard module in your template workbook.

I've assumed that the name of the worksheet in the template workbook which you want to be copied to a new workbook for each day of the current month is Template. Each new sheet name has the format ddmmmyy, e.g. 01May12, 02May12, etc. Also, the new workbook is saved with the file name format mmm-yyyy, e.g. May-2012. I'm sure you can work out which lines to change if these names are unsuitable.

Please Login or Register  to view this content.

wow! you are amazing! so I have a few questions. More then likely the document will be made prior to the month it will be used. Is it possible to ask the person creating the document for the date they choose?
The file will be named Snapshot Report_MonthYear and it would be great if it would save as a new workbook rathere then saving over the template. Which it looks like it did. GREAT! thank you thank you!

thanks!

Originally Posted by fasalazar

save as a new workbook rathere then saving over the template. Which it looks like it did.

No, it saves as a new workbook (the newWorkbook.SaveAs statement), leaving the template workbook unchanged.

Try this new code which prompts for the month number:

Please Login or Register  to view this content.