B

 https://eradigitalpro.blogspot.com/2020/01/10-text-only-blogger-templates.html

https://help.mjtnet.com/article/144-how-to-loop-the-loop

In Macro Scheduler there are three looping constructs:

1. Using a Label and a Goto statement
2. Using Repeat and Until
3. Using While and EndWhile

A loop may have conditional logic in it to decide whether the loop should continue or not.

Using Label and Goto

Here's a really simple never-ending (infinite) loop:

Hopefully that is self explanatory and doesn't need much saying about it.  The Label statement marks a point in the script.  The Goto statement causes execution to jump to the specified label. So in the above the script simply does the "// do something here bit" over and over and over again (until you stop the script or shut down the PC!).

Now, supposing you wanted to loop until a specific condition, say a specific window exists.  You could do:

So here all we're doing is only jumping back to start if the "Untitled - Notepad" window does NOT exist.

Or let's say you wanted to repeat the loop only 5 times.  You could do:

Here we have a loop counter "k" which we increment (add 1 to) in every iteration.  At the end we check to see if k is less than 5 and if so we loop back.  So the loop would stop when k reached 5.  This is a rather clunky way of waiting 5 times and many real programmers  hate goto statements, so a neater way is to use Repeat/Until which we'll look at next.

Using Repeat and Until

With Repeat/Until our "loop only 5 times" example becomes:

It's a bit neater, reads better and avoids the "spaghetti" code thing that overuse of Gotos could create. But at the end of the day the choice is yours.

Instead of a fixed number like 5 you might be looping through something dynamic like the lines in a text file or rows in Excel, and your Until condition would be checking for the loop counter becoming equal to the number of lines/rows:

Using While and EndWhile

With While/EndWhile we could replicate the "loop 5 times" loop:

The most noticeable difference is that we check the condition at the top of the loop.  That's why in the example above the condition is k<5. Try stepping through the code  with the debugger to see why that is.

Here's how we might implement our "Check for Untitled - Notepad" loop with a While/EndWhile:

While can take a "complex expression" as well.  That's one with a combination of conditions, e.g. let's say we want to loop only if it is Monday morning:

Confused? The DayOfWeek function returns the day number where 1 is a Sunday. So Monday is 2. If it's in the morning the hour must be less than 12. So our Loop condition must be "day is 2 AND hour is less than 12".

Breaking out of Loops Prematurely

Best practice is NOT to break out of a loop but you could jump out of one simply by using a Goto and Label.  You might set a label after your loop and have an If/Endif condition inside the loop which uses a Goto to jump to the label if your exit condition turns true. 

Remember, many hardcore geeks go a bit off colour if they see too many Gotos and if you're going to use an If/Endif anyway why not just set the loop condition to true and nest the code within your loop instead? We did exactly that in our While/EndWhile "Check for Untitled - Notepad" loop above.

https://www.youtube.com/watch?v=PLYTLrIbjco&pp=ygUsaG93IHRvIGxvb3AgdGhlIGFjdGlvbiBpbiBtYWNybyBzY2hlZHVsYXIgMTE%3D