Excel to Word loop

[macropod]

You destroyed the Wdobj object... This is why you have the error. Don't set it to nothing (Wdobj) until at the very end, when you know you are done with the object.

The code 'Set Wdobj = Nothing' appear both inside the loop and after the loop has ended, so it's the one inside the loop that's an issue. Another issue is that 'Wdobj.Quit' is also inside the loop.