Running vba Application.OnTime TimeValue events in closed workbooks

[Spoursy]

Is it possible to run vba Application.OnTime TimeValue events in closed workbooks?

I run the folling macros in a 365 coauthored work book

Private Sub Workbook_Open()
Application.OnTime TimeValue("09:00:00"), "TasksAt9"
Application.OnTime TimeValue("12:30:00"), "TasksAt1230"
Application.OnTime TimeValue("16:00:00"), "TasksAt4"
Application.OnTime TimeValue("16:01:00"), "CopyPasteDataFromDailyPerformanceToConsolidationSheet"
Application.OnTime TimeValue("16:02:00"), "ClearContentsDailyPerformance"

Thanks in Advance

 

[excel_learnerz]

No, it is not possible to run VBA Application.OnTime events in closed workbooks. This is because Application.OnTime relies on the Excel application instance to execute the VBA code at the specified time. When a workbook is closed, the Excel application instance is no longer running, so any scheduled Application.OnTime events in that workbook will not run.

If you need to run VBA code at specific times even when the workbook is closed, you can consider using an external scheduling tool or a Windows task scheduler to run a separate VBA script or batch file that opens the workbook and executes the necessary VBA code.

Alternatively, you can consider using a different approach to automate your tasks, such as using Power Automate or a third-party add-in that can run scheduled tasks in the background without relying on Application.OnTime.