title: VBA Excel MSXML2.XMLHTTP getelementsbytagname() not working
body: <p>Here is my code   </p>
  
  <pre><code>Sub loadrss()
      Dim http As Object, html As New HTMLDocument, topics As Object, titleElem As Object, topic As HTMLHtmlElement, i As Integer
      Set http = CreateObject("MSXML2.XMLHTTP")
      http.Open "GET", "http://antt.vn/rss/trang-chu.rss", False
      http.send
      html.body.innerHTML = http.responseText
      Set topics = html.getElementsByTagName("Item")
      i = 55
      For Each topic In topics
          Sheet7.Cells(i, 15).Value = topic.getElementsByTagName("title")(0).innerText
          Sheet7.Cells(i, 16).Value = topic.getElementsByTagName("link")(0).innerText
          Sheet7.Cells(i, 17).Value = topic.getElementsByTagName("pubDate")(0).innerText
          i = i + 1
      Next
  End Sub
  </code></pre>
  
  <p>but it alert an error with this row</p>
  
  <pre><code>Sheet7.Cells(i, 15).Value = topic.getElementsByTagName("title")(0).innerText
  </code></pre>
  
  <p>I don't know how to fix it, please help!!!</p>