Have Autorun Macros but can we stop them running at one particular interval

If the fact that the application ontime is still active, you could add an IF statement that checks if the VT value is a Friday and the VT time falls between 8:55 AM and 10:15 AM
You'll have to play around with that, it's just an idea that popped up

Please Login or Register  to view this content.

Hi There,

I'm reopening this thread not because of my original questions which I posted earlier (those 2 things have been resolved) but I have new ask and this one is on the similar lines as my earlier. Also, this could be a simple one and that's the reason I don't want to open up a new thread. Hope I'm not violating any procedures here

Ask:
I wanted a macro to autorun on a particular day and at particular time ---- Every Friday at 8:47 AM. Below is the codes (1) and (2) I have written based on the similar on what was given to me earlier. Not sure what is wrong but this is not working. Can you please look into it and correct this. Thanks in advance!!

Code-1

Please Login or Register  to view this content.

Code 2

Please Login or Register  to view this content.

If you want it to run on a friday at a specific time, just set that in a variable and set the application ontime to that date and time and forget about checking if then else.

The If then else was good for your first question because you wanted it NOT to run between two values.

What's in Workbook_Open ???
What's the name of the macro you want to run on friday morning?

My idea:

Place the code below in a Module
The Red line of code is the topmost outside the subs

Please Login or Register  to view this content.

In the Workbook_Open event

Please Login or Register  to view this content.

So every time the workbook is opened the macro is set to run on a friday at 8 47 AM

I also suggest you place this in the

Please Login or Register  to view this content.

Another way to calc the next Friday

Please Login or Register  to view this content.

@AlphaFrog: true,much simpler,