title: Open html file with Workbooks.Open allways in new workbook
body: <p>I use Workbooks.Open method to open local html file in excel. This method opens file in new workbook, so then I copy UsedRange into my current Workbook's ActiveSheet. Everything works fine except when I turn on Excel for the first time, do not modify any cell in it and press the button (in my custom add-in (xlam)) to open this html file. In this case, the file opens in the <b>current sheet</b>. How can I achieve to allways open this external file in other workbook or other sheet? Here is my code sample:</p>
  
  <pre><code>Dim tempWorkbook As Workbook
  Set tempWorkbook = Workbooks.Open("file:///C:/report.html")
  </code></pre>
  
  <p>This code opens html file in another workbook only if current active sheet was modified, but opens in current workbook if it was not modified by user before.</p>