Workbooks copy help

Make sure you have the trailing backslash in the TemplateFilePath. Also, try adding the .xlsm to the DestinationFileName

Here is another question based on the same file. If I wanted to save the file as instructed with the date at the end but also change the names of the sheets within the workbook to reflect the days of the upcoming week is that possible? I am thinking no or at least not without great difficulty.

Thanks!