Run a macro every 5.5 seconds

How can I run a macro exactly every 5.5 seconds (not every 5 or every 6 seconds)?

Well, there are probably several ways to do it. The first thing that comes to my mind is to use a loop that contains your macro plus a "Pause 5.5 seconds" inside the loop. So really, you are running it only once, but looping with a pause. Will that work for you?

1 Like

Thanks for the reply. Actually in my case it won't work because I don't want it to run 5.5 seconds after the last run but literally every 5.5 seconds regardless of when the last run was complete. Since the macro takes anywhere from 1-20 seconds (random each time) to run, I put a Semaphore Lock at the start of it so it won't twice simultaneously.

Thanks for clarifying. Sure you can solve that! I had no idea your macro ran for such a long time.

What you need is two macros. One macro that does your work (like you probably already have done) but a second macro that runs a loop like I was talking about, with a 5.5 second pause statement, BUT it runs your macro ASYNCHRONOUSLY. Do you know how to run a macro asynchronously?

image

This will solve your problem perfectly. Do you understand my advice? I'm heading out to lunch right now. If you don't understand, I can help you when I get back.

1 Like

Yes understood. Genius!! Thank you :slight_smile: