I would like to be able to automate a macro to run daily during the week using Task Scheduler or some other method. I don't really want to put the macro in the open event if I don't have to because the macro I've built will close the file when done, so if it's in the open event it will open, run the macro then close. This could make it difficult for revision.
Any ideas on how to set this up?