Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

extracting data website

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Extracting data from a website

Extracting data from a website

ResolvedVersion 2007

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!

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.

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Random Numbers

Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.