Run Various Macros at Various times Automatically Everyday

[sajeel]

I have 4 macros that need to be executed at different times. I need to leave the workbook open, so that it executes these macros daily without me having to do anything. I am able to get a Macro running at a specific time however unable to get mulitple macros to run at different times. Also a problem with executing it daily.

I used the Application.OnTime TimeValue. The Macros are in the individual Modules and the Application.OnTime.TimeValue sit in THIS WORKBOOK.

I will be very grateful for any help recieved. Thanks

[MarvinP]

Hi sajeel,

It seems to me all you need to do is put all OnTime lines in the same On_Open event to accomplish your goal. Like:

Please Login or Register  to view this content.

Putting your modules together or leaving them separate makes no difference.

I hope that is what you were trying to accomplish.
See http://msdn.microsoft.com/en-us/libr...ffice.11).aspx for the specifics and how to cancel you OnTime statement if you need to.