Hi guys, I have a report template that we update daily with raw data, and we email another copy of this report but only with a few tabs copied as values. There's a couple steps to it: Copy 5 tabs to a new workbook in the same folder, rename the file to include today's date, rename three tabs to include the current Month name like "Dec 2021 Summary", and closing all Excel instances so nothing is corrupted.
The code works but it takes 4-5 minutes to run...and I don't know if it's because the code needs a lot of memory or it's just inefficient. Was wondering if someone can look at it. Thanks!
A second note that's more of a question. This macro is stored in the report template so I have to open it to run. I've read that I can instead use a VBScript whether the file is open or not. How would I add another line of code and convert this to a script?
Bookmarks