Running a macro on specific day and time

[Freakazoid]

Hi all

I have written the following macros with help from the internet.

I am trying to get an already open Excel workbook to execute a macro every monday at 6:00:00 am.

But i get an error when the time is reached saying the macro "RunWhen" is not available in the worksheet.

Please Login or Register  to view this content.

Can anyone help me please

[Chippy]

This works for me. Put the code in a standard module, not a sheet module. For testing today, I've used vbWednesday instead of vbMonday, and a time in the near future.

Please Login or Register  to view this content.

[AB33]

Chippy! Great code! I have not done this stuff so far.

Please Login or Register  to view this content.

Am I right this code means, if the date set = today's date, excute Sheets("Sheet1").Range("A1") = 1 code? If I am right, this means I can call any macro once If Weekday(Date) = vbWednesday Then is set? Am I right?

[Chippy]

AB33, correct. But please start your own thread with your specific request if you have further questions about this.

[Freakazoid]

Hi Chippy

Thanks for the help, the code seems to be working if I activate it on the specified time, but it soes not activate by itself.

Any sugestions?

Please Login or Register  to view this content.

[Freakazoid]

Is there nobody that has a solution to my problem?

How to activate a macro, every monday at 6:00 am

Please Login or Register  to view this content.

[Chippy]

Thanks for the help, the code seems to be working if I activate it on the specified time, but it does not activate by itself.

Call AutoUpdateWhen from the Workbook_Open routine. Save, close and reopen the workbook any time before 6 am on a Monday and leave an Excel instance open or the workbook itself open for AutoUpdateOn to run at 6 am on Monday and again the next Monday a week later (it actually runs every day at 6 am but just reschedules itself if it isn't Monday). If you don't want to keep Excel/the workbook open like this have a look at using the Windows Task Scheduler to open and run the macro every Monday at 6 am.

[Freakazoid]

Thanks alot Chippy that was the last thing I needed to get it all working.