How to build a counter in the macro

[PeterKem]

Hi,

I am trying to build a counter in the Macro. For example, after repeating every 1000 times, I'd like to save the results, refresh the application program (it will run faster) by closing and opening the program again, and continue the next 1000s, so on.

Can I use a counter to do that ? Is there a better way to do so ?

Thanks,

[forumsupport]

Hello PeterKem,

You can use the Super Macro template to chain together the same macro and call it repeatedly separated the actions to refresh the application in between. For e.g. your Super Macro would look something as follows

1. Run Macro A.wksp (Repeat 1000 times)
2. Action to refresh the application
3. Run Macro A.wksp (Repeat 1000 times)
4. Action to refresh the application
5. Run Macro A.wksp (Repeat 1000 times)