I want to download the result of HKJC horse racing into Excel.
http://www.hkjc.com/chinese/racing/results.asp
or
http://www.hkjc.com/chinese/racing/r...eno=8&venue=HV
The actual size Saved by IE or other programming language should be round 40k.
But there is a javascript to rewrite the result.
Whatever I use,
ActiveSheet.QueryTables.Add(Connection:="URL;" & sURL ...)
URLDownloadToFile Lib "urlmon"
InternetReadFile Lib "wininet.dll"
nor
CreateObject("MSXML2.ServerXMLHTTP") => to get objHttp.ResponseText
all feedback me only around 10k and cut off the result part of the webpage.
which is the executed result of javascript on the above given page!!!
That javascript use document.write to rewrite the webpage and hide the RESULT from the original webpage.
I need the result, by download the webpage and CUT-off all javascript from it.
i.e. save the webpage from starting of "<body bgcolor"
Then, the horse racing data will appear properly on excel by ActiveSheet.QueryTables.
I don't want to save the webpage manually and cut-off the javascript by IE.
What can I do?
Bookmarks