Transferring Word to Excel -

[macropod]

The trick here is that the VBA errors out before getting to adApp.Quit.

I am aware of that but, since the error apparently occurs at
.Close SaveChanges:=False
a crashing macro will leave both a running Word session and an open document. The changes I suggested were to facilitate manually closing the document and terminating the Word session. Moreover, they will allow you to check which particular document is having issues and perhaps identify whatever is peculiar about it. If, for example, your document has formfield checkboxes, you'll need something like the code I posted here: http://www.vbaexpress.com/forum/show...l=1#post291047