Hello Greed,

That is correct. The workbook must be open for any macros to run. You could use your Task scheduler to automatically load the workbook so it will run at the specified time. You will need to write another macro to close the workbook automatically, if needed.