Hello PeterKem,
You can do something as follows
1. Let's say your macro is called A.wksp that repeats for 100 times using the repeat property of Workspace Macro Pro
2. Make a copy of the macro by right-clicking it and selecting Copy Macro. Call it B.wksp.
3. Now go to Tools Macro Editor and create a new macro and call these two macros from it one after another using the Run Macro command or alternatively by choosing a Super Macro template, chaining A.wksp and B.wksp together.
4. Now insert a Ctrl + S keystroke command in Excel between the two Run Macro commands in Main.wksp and in the Run Task command select the Repeat option to 100 and 1000 respectively.
So now your Main.wksp might look something as follows
1. Run Macro A.wksp (Repeat 100 times)
2. [Ctrl Down]s[Ctrl Up] in Microsoft Excel
3. Run Macro B.wksp (Repeat 1000 times)
Hope that helps |