javascript web page to excel RRS feed

  • Question

  • Dear All

    I have excel database of about 100 hyperlinks of webpages like this:


    All ones represent different products but have the same structure.

    I need to have content of these pages in excel. The main purpose is to get the shop and the price.

    So for example:

    SHOP           PRICE         15989    16990


    I tried web queries but not working on this kind of web page. (error acccured: This Web query returned no data.  To change the query, click OK, click the arrow on the name box in the forumula bar, click the name of the external data range for the Web query, right-click the selection, and then click Edit Query.)

    I went through many scrapers tools (eg. outwit, data miner) but could not find the one manage to solve this issue.

    I am rather basic in VBA but it could be the only solution.

    Is there a way to extract data from those hyperlinks each one in separate sheet to get the needed data?

    Or maybe there is easier way to gather information about Price and Shop for each product and placed it in excel?


    Thursday, October 23, 2014 8:15 AM