Solved How To Retreive Data From A Website And Display In Table

[Pedroc1999]

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

 

[Pedroc1999]

Bump

 

[UsernameIssues]

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.

 

[Pedroc1999]

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

 

[tom982]

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

 

[Pedroc1999]

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