A few years ago at a job I created a macro that would refresh a table and save the results to a network folder so it was ready to review when everyone got into the office. I was able to do this using Windows Scheduled Tasks. The one negative to this was that the computer had to be on and unlocked when it was time for the task schedule to run.
I'm at a new company and need to setup something that does the same thing. However, I don't have a computer that will be unlocked at the the time the macro would execute. Is it possible to trigger a macro at 3am with a computer not being on and connected? We have Office 365, so since it's in the cloud, I'm wondering if this is now an option vs older local versions of excel.
Thanks!
I'm at a new company and need to setup something that does the same thing. However, I don't have a computer that will be unlocked at the the time the macro would execute. Is it possible to trigger a macro at 3am with a computer not being on and connected? We have Office 365, so since it's in the cloud, I'm wondering if this is now an option vs older local versions of excel.
Thanks!
