Can't delete or overwrite Word documents created by an Excel macro

[fabcat1]

I've created a macro that takes the content of an excel sheet and for each line creates a Word document and fill the bookmarks with the content of the corresponding cells in the sheet.



But if I run the macro twice, I have an error message saying "Word cannot save this file because it is already open elsewhere"

When I try to delete the Word document i have a message saying " The action can't be completed because the file is open in Word", but Word is closed

So far I don't know how to fix this

Any clue ?

 

[Peter_SSs]

Duplicate to: post 3 in Loop problem

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.