title: How to fetch data from XML file to Excel sheet using VBA
body: <p>I used the following code to fetch data from XML to Excel. 
  But the problem is, the results are opened in a new workbook "<code>Book1</code>". But I want to get the results in a specific worksheet in the same Excel where I have this macro.<br>
  Please note that I don't want to create schema in the code, as the schema changes for all the XMLs. Below mentioned code does not need schema to be specified. It can dump the results in new Excel sheet with the proper column names. So, Please let me know how can I get the results in the <code>sheet2</code> in the same workbook?</p>
  
  <pre><code>Sub ImportXMLtoList()
   Dim strTargetFile As String
   Application.DisplayAlerts = False
   strTargetFile = "C:\example.xml"
   Workbooks.OpenXML Filename:=strTargetFile, LoadOption:=xlXmlLoadImportToList
   Application.DisplayAlerts = True
  
  End Sub
  </code></pre>