Day/Time Trigger to start macro, then 1 minute regular interval thereafter...

bigdog1892

New member
Hello,

I would like my macro to begin at 8am in the morning, every day of the week. To do so I have set the day/Time trigger. However, after the first instance I would like it to trigger every minute thereafter. I began by using the day/time trigger (8am) and then using a loop (repeating 1000 times) and approximately timing the macro to run for 60s, however this was not reliable and over time went out of sync. Its imperative that the macro runs for exactly 60s, and then repeats, with no margin for error.

Note: I can do this by manually running a regular interval (having no day/time trigger) although it isn't always reliable.

Any help would be greatly appreciated

regards BigDog
 

Dm114

Well-known member
Hello,

I would like my macro to begin at 8am in the morning, every day of the week. To do so I have set the day/Time trigger. However, after the first instance I would like it to trigger every minute thereafter. I began by using the day/time trigger (8am) and then using a loop (repeating 1000 times) and approximately timing the macro to run for 60s, however this was not reliable and over time went out of sync. Its imperative that the macro runs for exactly 60s, and then repeats, with no margin for error.

Note: I can do this by manually running a regular interval (having no day/time trigger) although it isn't always reliable.

Any help would be greatly appreciated

regards BigDog
You could use this Trigger (below)
20240326_190315.jpg
 

Dm114

Well-known member
Am I missing something: why do you have a Day Of The Week constraint with every day specified? Isn't that redundant?
You're 100% right! 👍

When I first wrote it, I hadn't the exact request in mind and thought it was only on some days of the week such as from Monday to Friday. Then I checked the original need and added missing days so the result now becomes "Every day"...

Let's say that if is redundant (and it is), it shows how to tune this trigger to adapt it to the exact needs. 😉
 
Top