How To Retreive Data From A Website And Display In Table


  1. Posts : 1,326
    Windows 7 Ultimate x86
       #1

    How To Retreive Data From A Website And Display In Table


    I am trying to 'track' the prices of computer parts on 2 different online stores, I would like to have excel display the product name , price , and total price of all in a table. Is this possible.

    example product :

    Corsair Memory Vengeance Low Profile Jet Black 8GB DDR3 PC3-12800 CAS 11 Dual Channel Desktop - CML8GX3M2B1600C11 - Scan.co.uk
      My Computer


  2. Posts : 1,326
    Windows 7 Ultimate x86
    Thread Starter
       #2

    Bump
      My Computer


  3. Posts : 10,485
    W7 Pro SP1 64bit
       #3

    I don't know of a way to do what you described from within Office; but you can do it with a scripting tool like AutoHotkey or AutoIt. If this is something that you want to use for months, then it might be worth learning how to script it; otherwise, checking/entering the info manually would be easier.
      My Computer


  4. Posts : 1,326
    Windows 7 Ultimate x86
    Thread Starter
       #4

    Thank you. I think the problem is that part of teh page is flash and it complicates it. Im goi g to mark this as solved but if someone wants to gjve an answer please feel free to do so
      My Computer


  5. Posts : 2,663
    Windows 8.1 Pro x64
       #5

    That's no easy task, I'm afraid. Learn to program, then use an HTML agility pack to retrieve the information you need from the website.

    Well, that or just spend the 30 or so seconds to check a website each day. eBuyer is cheaper by the way:

    Cheap Laptops, Computers and Cheap LCD TVs | Ebuyer.com

    For my build, eBuyer was cheaper than Scan, OcUK, Amazon and eBay on every component except one - which they didn't stock. Delivery was free and I got everything two days after my order, then I had to wait a week for my RAM to come from Amazon.

    Well, what do you know, it's even cheaper on Amazon:

    Corsair CML8GX3M2A1600C9 LP Vengeance 8GB (2 x 4GB) 1600MHz CL9 DDR3 Memory Module Kit: Amazon.co.uk: Computers & Accessories

    That's a rarity!

    Tom
      My Computer


  6. Posts : 1,326
    Windows 7 Ultimate x86
    Thread Starter
       #6

    Yes i know but for my current uild it was about £10 cheaper without posting but when teh time comes im going with ebuyer. I allready know batch and lua. Im workibg on auto
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 06:54.
Find Us