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

[terrycloth.livejournal.com]

Okay, so the problem is probably that the event call doesn't exit until the fetch is complete, which means that all the events are still on the stack until the last one finishes.

Could you move the 'get a new different batch' step into the outer loop, with some sort of delay so that it didn't try to fetch multiple batches concurrently? Or it could wait on a variable that you set in the event handler (checking the variable every X time period until it's true, then fetch a new batch).