Sorry Mac folks, this is only a PC solution. The ONLY CATCH to this solution, is that the PC will need to be on during the scheduled time. With this solution, you will be able to customize the frequency and exact time(s) this automation will need to be executed. This article will go through how to utilize the Windows Task Scheduler application (don’t worry, this comes installed with most Windows PCs) to automatically open an Excel file, run it’s VBA code, save the file, and finally close the Excel file. As I work through getting this setup, I figured I would document my solution for everyone. I’m currently working on a consulting project where a VBA macro within an Excel file needs to run every morning before folks get into the office.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |