title: Scraping WEBSITES with nested elements VBA
body: <p>I would like to get a value where elemets are nested<br>
  EX :   </p>
  
  <blockquote>
  <pre><code>    Set myhtml = .Document
  End With 
  </code></pre>
    
    <p>with myhtml
        Set List = .getElementsbyTagName("TD").getElementsByTagName("span").getelementbytagname("a")</p>
  
  <pre><code>For Each l In List
      If InStr(1, l.innerHTML, "8332103") &gt; 0 Then
          Range("A1").Offset(r, 0).Value = l.innerText
          r = r + 1
      End If
  Next
  
  Set myhtml = Nothing
  Set ie = Nothing
  End Sub
  </code></pre>
  </blockquote>
  
  <p>This procedure gives me back an error (the error is object doesn't support this property or method) here:</p>
  
  <blockquote>
    <p>with myhtml
    set list=
    .getElementsByTagName("TD").getElementsByTagName("span").getelementbytagname("a")</p>
  </blockquote>
  
  <p>Any suggestions?</p>