Procedure/macro to run automatically every hour

[waynered]

VBA - I want to run a set of statements every hour on the hour for the lifetime of the workbook being open - Any help appreciated.

Wayne

 

[s-o-s]

If your macro is called Macro1

Insert in 1st line of code in Macro1

Application.OnTime Now + TimeValue("01:00"), "Macro1"


Then in the Thisworkbook module add the following macro.

Private Sub Workbook_Open()
Call Macro1
End Sub

 

[waynered]

Thanks...It worked!

 

[suprsnipes]

I found this helpful also, thanks

 

[somolov]

If your macro is called Macro1

Insert in 1st line of code in Macro1

Application.OnTime Now + TimeValue("01:00"), "Macro1"


Then in the Thisworkbook module add the following macro.

Private Sub Workbook_Open()
Call Macro1
End Sub

For some reason, I can't close the workbook into which I entered this code :/ anyone know why?

Thanks!

 

[Rguarinb]

If your macro is called Macro1

Insert in 1st line of code in Macro1

Application.OnTime Now + TimeValue("01:00"), "Macro1"


Then in the Thisworkbook module add the following macro.

Private Sub Workbook_Open()
Call Macro1
End Sub

It works Great for me.
Thank you