Automatically Run Macro everyday

[mjones18]

Hello,

I have a Macro called WeatherData which I would like to have run everyday automatically at 7:00am in the morning. If the workbook is left open, does anyone know how to easily automate this process?

Thank you.

 

[ranman256]

paste this macro into the module with YOUR macro.
here I set the time in cell B2. (change if you need)
run : RunTimerApp
it will load and run your macro (here its: mMyMacro ) at the given time.

Public Sub RunTimerApp()
Dim vTim
vTim = Format(Range("b2").Value, "hh:nn:ss")
Application.OnTime TimeValue(vTim), "mMyMacro"
End Sub

 

[mjones18]

Thanks!

I put the code in the Module in the top line. Where is cell b2 and do I put a time in the cell? (i.e., 07:00:00) Below is the slightly updated code where I changed "mMyMacro" to "WeatherData" Is this correct?
Public Sub RunTimerApp()
Dim vTim
vTim = Format(Range("b2").Value, "hh:nn:ss")
Application.OnTime TimeValue(vTim), "WeatherData"
End Sub