View Single Post
  #1 (permalink)  
Old 11-09-2007, 11:29 AM
Topper Fox Topper Fox is offline
Junior Member
 
Join Date: Oct 2007
Posts: 2
Default Save every time or not at all?

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
Reply With Quote