Force close an incompatible workbook
<p>I am manipulating by code a large number of Excel files. I go through them automatically: open one file, do some operations and then close it.</p>

<p>For some files, at the place of</p>

<pre><code>ActiveWorkbook.Close SaveChanges:=False
</code></pre>

<p>an error pops-un, which stops my automation:</p>

<p><a href="https://i.stack.imgur.com/DGm6Y.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DGm6Y.png" alt="enter image description here"></a></p>

<p>Does anyone know how to force-close such a workbook (and other workbooks) and do not let it stop my automation?</p>

<p><strong>Edit 1:</strong> I try to look into the VBA code of <code>ThisWorkbook</code>, but <strong>they are protected by a password</strong>. I think this is their common point.</p>

<p><a href="https://i.stack.imgur.com/lD38r.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lD38r.png" alt="enter image description here"></a></p>