Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: How To Retreive Data From A Website And Display In Table


27 Dec 2012   #1

Windows 7 Ultimate x86
 
 
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 System SpecsSystem Spec
.

28 Dec 2012   #2

Windows 7 Ultimate x86
 
 

Bump
My System SpecsSystem Spec
01 Jan 2013   #3

W7 Pro SP1 64bit
 
 

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 System SpecsSystem Spec
.


01 Jan 2013   #4

Windows 7 Ultimate x86
 
 

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 System SpecsSystem Spec
01 Jan 2013   #5

Microsoft Community Contributor Award Recipient

Windows 8.1 Pro x64
 
 

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 System SpecsSystem Spec
01 Jan 2013   #6

Windows 7 Ultimate x86
 
 

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 System SpecsSystem Spec
Reply

 How To Retreive Data From A Website And Display In Table




Thread Tools



Similar help and support threads for2: How To Retreive Data From A Website And Display In Table
Thread Forum
How to retreive deleted browser history on Internet Explorer Browsers & Mail
Cannot reinstal Windows7 - cannot retreive disk information Installation & Setup
Corrupted Partition Table on External USB Data Backup Drive General Discussion
Where do I retreive a core dump and how do I analyze it? BSOD Help and Support
Trouble exporting data to excel from website via IE9 Browsers & Mail
Internet cannot display the website Browsers & Mail
Retreive files from WET General Discussion

Our Sites

Site Links

About Us

Find 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 10:01 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33