title: Get text from website with VBA
body: <p>I Need to create a VBA Macro which takes a specific Website and search for the ID. When the ID is found I Need to take the text and copy it into Excel.</p>
  
  <p>Here is the source code of the Webiste:</p>
  
  <pre><code>&lt;tr&gt;
  &lt;td style="width: 10%; color: blue" valign="top"&gt;&lt;a name="111" id="111"&gt;111&lt;/td&gt;
  &lt;td&gt;&lt;pre&gt;  
      Some text I Need in excel
  &lt;/pre&gt;&lt;/a&gt;&lt;td&gt;
  &lt;/tr&gt;
  </code></pre>
  
  <p>I Need the text between "pre"</p>
  
  <p>This is my try in VBA:</p>
  
  <pre><code>Set IE = CreateObject("InternetExplorer.Application")
  IE.Visible = True
  IE.Navigate  Website_URL
  
  Do While IE.Busy And Not IE.readyState = READYSTATE_COMPLETE
    DoEvents
  Loop
  Set Document = IE.Document
  
  Dim SearchValue As String  
  Set Element = Document.getElementById(SearchValue).getAttribute("pre")
  
  Range("I1").Select
  ActiveCell.FormulaR1C1 = Element
  </code></pre>
  
  <p>I also tried instead of ".getAttribute" other methods and also tried to use Element As an String but it also didn't work.</p>
  
  <p>It would be awesome if someone could help me with my Code :D</p>