title: EXCEL Macro to open XML files as a XML table rather than a read only workbook
body: <p>I'm using the following code to open multiple xml files, however they are opening as a read only workbook, however I require it to open as an XML table, any suggestions?</p>
  
  <p><strong>Code:</strong></p>
  
  <pre><code>Sub AllFolderFiles()
      Dim wb As Workbook
      Dim TheFile As String
      Dim MyPath As String
      MyPath = "C:\Documents and Settings\"
      ChDir MyPath
      TheFile = Dir("*.xml")
      Do While TheFile &lt;&gt; ""
          'Call Logs 'This calls for Macro2 to run
          Set wb = Workbooks.Open(MyPath &amp; "\" &amp; TheFile)
          MsgBox wb.FullName
          'wb.Close
          TheFile = Dir
      Loop
  End Sub
  </code></pre>