Excel VBA Errors For Long Processing

I have a very long (> 2 hr) macro that shifts through thousands of files and creates a table of contents (more or less). Anyway, the program will operate just fine when I am also working at the same PC but if I walk away for an hour, Excel will sometimes generate an error. I believe that it has something to do with the PC going idle although it really isn't going idle because I turn off sleep and hibernate while running the macro. Also, the error does not seem to occur in the same place each time although it has happened at one point a couple times. See below:

Please Login or Register  to view this content.

I will get an automation error here (forgot to get the code).

Besides the power settings which are set to "High Performance" (i.e. no sleep, no HDD turn off, etc), is there something else in the PC that would cause this behavior? Something perhaps that is not controlled by the power control settings but still goes to sleep when the PC is idle.


Thanks,

Mark

I change sheets in the output workbook but I haven't tried that in the macro workbook. I will give that try and report back.

Thanks

Unfortunately, that didn't work either and I tried multiple things. Updating cells, recalculation, activation, etc. It just seems that Excel is going to sleep even though the PC stays awake.

Try to insert a DoEvents line just before the Next line …

I already have that in the code.