Est. Budget: $20.00
I have an Excel Macro which scraps prices of Car from www.CarSales.com.au
It is working perfectly but the speed is very slow as each page has lot of images in so IE sync takes lot of time.
Below is the code it uses at the moment:
Function GetHtmlDocIE(ByVal url As String) As Object
Do While IE.readyState <> READYSTATE_COMPLETE
Application.Wait Now + TimeSerial(0, 0, 1)
Set GetHtmlDocIE = IE.document
End Function ...