my MSXML2 code not working after 24. loop

42 Views Asked by At

the code below doesn't save the data, usually after 24 loops. why might that be? thank you.

Public Sub XmlHttpTutorial()
For x = 1 To 50
Dim xmlhttp As New MSXML2.XMLHTTP60, myurl As String
myurl = "https://www.etsy.com/shop/SilverHandwriting/reviews?page=" & x
xmlhttp.Open "GET", myurl, False
xmlhttp.send
Sheets("sayfa1").Cells(x, "a") = xmlhttp.responseText
 Next x
End Sub
0

There are 0 best solutions below