Hello,
i need to scrape with a VBA Macro the odds that are on this link: Kukesi - Partizani, 03.05.2022 - H2H stats, results, odds
I have tried with this VBA code:
Public Sub Scraping_MatchQuote()
Worksheets("Foglio1").Select
urlBetExplorerMatch = "Kukesi - Partizani, 03.05.2022 - H2H stats, results, odds"
Set http1 = CreateObject("MSXML2.XMLHTTP")
http1.Open "POST", urlBetExplorerMatch, False
http1.Send
While http1.READYSTATE <> 4
DoEvents
Wend
Text1 = http1.ResponseText
Sheets("Foglio1").Cells(1, 1) = Text1
But on the output i cant see the part of the table with the odds that i want to scrape..
Can someone help me with a example of code ?
Thanks
i need to scrape with a VBA Macro the odds that are on this link: Kukesi - Partizani, 03.05.2022 - H2H stats, results, odds
I have tried with this VBA code:
VBA Code:
Public Sub Scraping_MatchQuote()
Worksheets("Foglio1").Select
urlBetExplorerMatch = "Kukesi - Partizani, 03.05.2022 - H2H stats, results, odds"
Set http1 = CreateObject("MSXML2.XMLHTTP")
http1.Open "POST", urlBetExplorerMatch, False
http1.Send
While http1.READYSTATE <> 4
DoEvents
Wend
Text1 = http1.ResponseText
Sheets("Foglio1").Cells(1, 1) = Text1
VBA Code:
But on the output i cant see the part of the table with the odds that i want to scrape..
Can someone help me with a example of code ?
Thanks