title: Import XML into worksheet not workbook
body: <p>I am trying to have Excel import 200 .xml files into separate worksheets.
  I have some code that creates new worksheets, and that works. However I can't seem to find the proper code to import an .xml file into a worksheet rather then a workbook. I was hoping:</p>
  
  <pre><code>Workbooks.Worksheets.OpenXML
  </code></pre>
  
  <p>would work, but alas.  </p>
  
  <p>Is there a way to do this, or should I import them into a new workbook, copy that worksheet, close the newly created workbook without saving and so on?</p>
  
  <p>For those interested: I found the quick and dirty method on this site as well: <a href="https://stackoverflow.com/questions/13620011/how-to-fetch-data-from-xml-file-to-excel-sheet-using-vba-macro?rq=1">How to fetch data from XML file to Excel sheet using VBA</a></p>