save results after N times macro run

[PeterKem]

Hi,

Is there a way that I can save the results after runing macro for 1000 times and continue the rest of the macro ?

FYI: My macro is to copy a name from one cell of column1 in the Excel, run a picture creating program, paste the picture onto column2 of the same row. After repeating 1000 times, I would like the Macro to save the Excel file and continue to run the next 1000 times, and so on.

Thanks,

[forumsupport]

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