I already see some laptops burned just running all night long …Do you think my PC would go haywire if I use it for a month?
No as the incomplete is the original post … As a reminder :
The better original explanation & attachment, the better & quicker solution !
As I do not think any helper has more time to waste on this subject,
better is you first try to load the first 1000 pages
and revert how many time it needs on your end …
So I was wrong for the duration : in an utopian worldI used the shahin code.
If Not Html.querySelector("p.item__desc-phone span") Is Nothing Then Cells(R, 3) = Split(Html.querySelector("p.item__desc-phone span").innerText, "Phone: ")(1) End If If Not Html.querySelector("p.item__desc-url span") Is Nothing Then Cells(R, 4) = Split(Html.querySelector("p.item__desc-url span").innerText, "url: ")(2) End If Next I End With Next pagenum End Sub
in the code of the web page it is written in the two versions: url and website.First error in red : "url: "
Do you see this red text in the webpage display of any school ?!
Compare with the phone part …