I need to schedule a macro to run every n minutes. I will use Application.OnTime, unless there is a better method. However, I would like more info than I can find at MSDN or in Help or in 3 books I have.
If OnTime is a method of the Application object, does it trigger regardless of whether the workbook is open?
What happens if Excel is not avaiable at the target time. Will the macro run the next time I open Excel?
To cancel a scheduled macro, it appears as though I need to know the exact scheduled time. Is this correct?