Large macro loop times out

[rossg]

Hi,

I have a macro that produces around 1500 documents. This is about 1gig of data and takes about 7hours

they are produced 1 at a time via a loop but after about 700 or so the marco always stops.

it doesnt bring up and error message it just stops working. i can then subsequently start it again for the remiander but does anyone have an idea why it might just stop?

is there a default loop counter, or something default within excel that wouldnt let this continue? or more likely a hardware issue ie not enough ram?

[Norie]

There aren't any defaults like that but you might be right about memory.

Hard to tell what the problem is and how to fix it without seeing the code.

[OllieB]

Please post the code as Norie suggested, and I will happily have a look at it

[abousetta]

Make sure that you are clearing memory as you move along. For example arrays can be deleted, objects can be set to nothing, strings can be set to nullstring, etc. This can clear up memory between loops.

I have macros that run for days and no issues even though when they run they take up ~80% of my 12 GBs of RAM and almost 100% of my CPU.

abousetta

[rossg]

thanks ill look into the nullstring and deleting objects between loops.

if it still doesnt work ill post the code on a new thread

[abousetta]

OK. Good luck.

abousetta