For Loop

claressa.lynne

Forums

Hello,
I am sure this has come up before but does anyone know how you can put a for loop similar to C++ but in IDEA code? I am trying to have a portion of my macro run through the same code over and over again until a final database is formed that doesn't have any outputs.
Any guidance would be much appreciated.
Thanks!
-Claressa

scotchy33 Fri, 09/11/2020 - 13:47

You could use the Do Until Loop, see below:
 
Set db = Client.OpenDatabase("??????.IMD")
x = db.Count
           Do Until x = 0
 ' Do whatever you want to do to the database here:
 
           Loop  
           Set db = Nothing