Don't spaghettify logic like this. The code/workbook that's responsible for opening a resource (be it a workbook, a file, a database connection, anything) should be the code that's responsible for closing that resource / cleaning up. — Mathieu Guindon21 mins ago
Work flow is Copy Previous Year Reports Folder, Update Following Templates, Save, Close. There are 19 workbooks in the Source Folder and in the NewYear Folder. Each Work book has to save the final data from the end of the year(the "YTD ACTUAL" pages) along with resetting and prepping the month sh...