TMP file not found error when creating multiple workbooks in a loop

[SamT]

Try adding

Do Events

Right after that line



"Do Events" tells the code to let Windows handle everything that just happened before continuing. It's not a real bad idea to use Do Events whenever the code does important things.

A cursory scan of your code sees ~8 places where Do Events could be appropriate.