Or Maybe I Can't Do This

[rowyn]

Hrmph. My report gets through about 10 iterations, then crashes with a stack-overflow error. Which appears to be caused by Excel VBA call stack filling up with my auto-generated macro calls. Googling about for "how to clear the call stack" has not made me optimistic about my odds of getting around this via VBA.  x.x

Comments

[whitefangedwolf.livejournal.com]

It sounds like you need your code logic to look something like the following:

For Each batch_to_fetch In list_of_batches_to_fetch
      'Grab the batch data'
      Do
             'Check if data is refreshed
      Loop While {Data is not refreshed}
      'Save batch under a new filename
Next