title: Macro to import local .html file to excel
body: <p>I have an Excel spreadsheet which compares data from a TXT file with a UDL file. These formats import easily into my spreadsheet.</p>
  
  <p>Then I attempted to import a locally stored .html file into this spreadsheet through a macro button, I did not succeed writing my own code nor finding correct code on the internet.</p>
  
  <p>What I need help with:</p>
  
  <ol>
  <li>Press button and select a locally stored .HTML file</li>
  <li>Convert it to xlsx</li>
  <li>Automatically adding the new xlsx file to a tab in the original spreadsheet. </li>
  </ol>
  
  <p>My .HTML file converts perfectly to xlsx with the code below:</p>
  
  <pre><code>Sub Open_HTML_Save_XLSX()
  
  Workbooks.Open Filename:="C:\Temp\Example.html"
      ActiveWorkbook.SaveAs Filename:= _
          "C:\Temp\Example.xlsx", FileFormat:= _
          xlOpenXMLWorkbook
  
  End Sub
  </code></pre>