title: Excel OnTime Events Scheduler
body: <p>I need to run my excel VBA daily at a specific time. I google the ontime method, however I dont get a comprehensive understanding from it. I would bring up this to clean up my confusion of ontime method.</p>
  
  <p>Does the containing excel workbook have to be open for ontime method before it runs. If yes, Is there a way to open the excel workbook automatically at a specific time.I know it mite be done by Timer or a Windows task Scheduler.
  Could someone work me through this. Is my current code properly constructed for automated task scheduler?</p>
  
  <p>My current code looks like this:</p>
  
  <pre><code>Sub StartTimer()
  Application.OnTime EarliestTime:=TimeValue("11:15:00"), Procedure:="rune", _
      Schedule:=True
  End Sub
  
  Sub rune()
    SourceOneUpdate
    SourceTwoUpdate
    SourceThreeUpdate
    GenerateReport
  End Sub
  
  Private Sub workbook_open()
    StartTimer
  End Sub
  </code></pre>
  
  <p>This is based on the idea from this post: <a href="http://www.cpearson.com/excel/OnTime.aspx" rel="nofollow noreferrer">http://www.cpearson.com/excel/OnTime.aspx</a> which mite be helpful. Even this workbook is open, its not running automatically. Could someone help me on this to see why this is not working properly.</p>
  
  <p>Thanks in advance.</p>