Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Extracting data from a website
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Extracting data from a website
Resolved · Urgent Priority · Version 2007
Reply Tue 9 Aug 2011, 15:44Delegate Jonathan said...
Jonathan has attended:
Excel VBA Intro Intermediate course
Extracting data from a website
Hi. I have a list of names in Excel.
1.John
2.Jane
3.Jenny
4.Jacob
....
....
50.James
On a website there is a spreadsheet with various bits information about these people (age, income, sex, children..). The names on the website are not in the same order as in the Excel spreadsheet. Is it possible to write a macro to extract a specific part of the website spreadsheet (eg. only the income column relating to the various people) into the excel spreadsheet?
Thank you in advance!
For upcoming training course dates see: Pricing & availability
RE: Extracting data from a website
Hi Jonathan, thanks for your query. This is possible, but will involve some coding. The following link runs you through a slightly different example of getting data from a website, but the basic principles of what you will have to do are the same.
http://www.mrexcel.com/tip072.shtml
My first stop however, would be to run a web query to the site to see if I could port the table of data directly into Excel. There's a good (2003 based) walkthrough here:
http://www.mrexcel.com/tip103.shtml
Look for Get External Data - From Web on the Data tab in Excel 2007. If you can get it into Excel that way the rest should be simple.
Hope this helps,
Anthony
Thu 18 Aug 2011: Automatically marked as resolved.
|