title: Copy all sheets from one (closed) workbook to another "
body: <p>I'm trying to copy all sheets from one book to another  </p>
  
  <pre><code>Windows("test.xls").Sheets.Copy Before:=Workbooks(ThisWorkbook).Sheets("00")
  </code></pre>
  
  <p>Error - type mismatch !<br>
  "test.xls" is in the same folder as ActiveWorkBook.<br>
  Especially - is there a way to do this without opening "test.xls" ?</p>