title: VBA Macro scraping odds data from Betexplorer
body: <p>i need to scrape with a VBA Macro the odds that are on this link:</p>
  <p><a href="https://www.betexplorer.com/soccer/albania/superliga/kukesi-partizani/zHiqu2S9/" rel="nofollow noreferrer">Betexplorer link</a></p>
  <p><a href="https://i.stack.imgur.com/7VbFQ.png" rel="nofollow noreferrer">Betexplorer example image</a></p>
  <p>I have tried with this VBA code:</p>
  <pre><code>Public Sub Scraping_MatchQuote()
  
      Worksheets(&quot;Foglio1&quot;).Select
  
      urlBetExplorerMatch = &quot;https://www.betexplorer.com/soccer/albania/superliga/kukesi-partizani/zHiqu2S9/&quot;
  
      Set http1 = CreateObject(&quot;MSXML2.XMLHTTP&quot;)
      http1.Open &quot;POST&quot;, urlBetExplorerMatch, False
      http1.Send
  
      While http1.READYSTATE &lt;&gt; 4
          DoEvents
      Wend
  
      Text1 = http1.ResponseText
      Sheets(&quot;Foglio1&quot;).Cells(1, 1) = Text1
  
  End Sub
  </code></pre>
  <p>But on the output i cant see the part of the table with the odds that i want to scrape..</p>
  <p>Can someone help me with a example of code ?</p>