title: Application.OnTime VBA without closing and opening excel
body: <p>I have written a macro using Application.OnTime macro that works if I manually execute the macro.  I'm trying to automate this process so I don't have to write Application.OnTime in
   "This Workbook"  or (Private Sub Workbook_Open()   Most of you do this because you can have windows scheduler open the workbook at a certain time which starts the macros on open.  I CANNOT USE SCHEDULER.</p>
  
  <p>Because I am not able to use windows scheduler I will keep the workbook open and the timer should refresh my data then Call "my Macro"  at a certain time everyday.</p>