Results 1 to 6 of 6

how to download webpage by skipping javascript

Threaded View

  1. #1
    Registered User
    Join Date
    12-10-2010
    Location
    Hong Kong
    MS-Off Ver
    Excel 97
    Posts
    13

    Unhappy how to download webpage by skipping javascript

    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?
    Last edited by catjoke; 12-30-2010 at 12:52 AM. Reason: Solved by myself.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1