Save every time or not at all?

[Topper Fox]

I have a macro running other macros. It copies data from the web into Notebook and converts it into comma deliminated format and changes all the spaces in the data to commas.

Saving after each download is excessive and is bogging down the process. I would like to have a save after every 10th record...

Example

Run Macro Setup:
1) Run macro GetData - Repeat 10 times
2) Run macro SaveData - Repeat Once
3) GOTO 1) - Repeat 76 times

In this example ... I will be obtaining statistics for 760 players and saved 76 times.

Can you suggest a way to do this?

Thanks

[forumsupport]

Hello,

Yes, you can achieve your objective as follows

1) Let's say your main macro is called Main.wksp

2) Call the macro GetData.wksp from Main.wksp using Run Macro command in Macro Editor. In the Run Macro command, you can specify the Repeat property to run it 10 times.

3) Call Savedata.wksp from Main.wksp and run it only once by not specifying the Repeat property.

4) Now, specify the Repeat property of Main.wksp in the main application window under Properties section and specify 76 there.

Hope that helps!