+ Reply to Thread
Results 1 to 3 of 3

Web scraping issue - HTML code scraped in VBA differs from source code in the website

  1. #1
    Forum Contributor
    Join Date
    11-12-2010
    Location
    HK
    MS-Off Ver
    Excel 2010
    Posts
    189

    Web scraping issue - HTML code scraped in VBA differs from source code in the website

    Hi everyone,

    I got an issue with web scraping with this website (http://www.hkexnews.hk/sdw/search/search_sdw.asp). Specifically, after inputting the stock code (e.g. 00005) and click Search, a result page will then be shown. Here's my issue, I have been using a VBA procedure to scrap the result page information for more than a year. But, there was a official modification on the result page layout recently. After that, my VBA procedure is no longer useful. I found that the code scrapped from the web by the VBA procedure is different from that shown on Chrome (they are the same in the past so that the procedure works). I wonder whether this issue relates to the language of javascript. Can anyone help me?
    Thanks in advance

    Here's my code
    Please Login or Register  to view this content.
    English is not my first language

  2. #2
    Forum Contributor
    Join Date
    11-12-2010
    Location
    HK
    MS-Off Ver
    Excel 2010
    Posts
    189

    Re: Web scrapping issue - HTML code scrapped in VBA differs from source code in the websit

    no one can give me a hand?

  3. #3
    Forum Contributor
    Join Date
    11-12-2010
    Location
    HK
    MS-Off Ver
    Excel 2010
    Posts
    189

    Re: Web scrapping issue - HTML code scrapped in VBA differs from source code in the websit

    I double check with the webpage source code and found that the value of the last input type below (name="sessionToken") changes every time I open the webpage.

    HTML Code: 
    But in the vba procedure which I have been using, there is no such input type. Is this the reason of fail?
    Please Login or Register  to view this content.
    please help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Importing website source code into excel
    By Schwizer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2013, 06:57 PM
  2. Macro to get source code from a website.
    By terbart in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-28-2013, 09:26 AM
  3. Parse Data from HTML Code / Website to Excel
    By rkymtns in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2013, 10:54 PM
  4. Help needed
    By RawSodium in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2013, 09:59 PM
  5. Display website from html code in sheet
    By janschepens in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2012, 03:32 AM
  6. Reading HTML source code
    By Chinnick in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2010, 03:38 PM
  7. How to save HTML source code from VBA?
    By Jaymond Flurrie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-22-2008, 06:15 PM
  8. [SOLVED] html source code into Excel
    By pwwatson in forum Excel General
    Replies: 0
    Last Post: 09-04-2005, 09:05 PM

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