Import multiple web pages 1

[JPJeffery]

I have 113 pages I want to import in to Excel (2010). To be more precise, they're two tables in 113 pages (they're golf scores hosted on a website that's closing down).

I know I can copy and paste then choose 'Refreshable Web Query' and run through the wizard but that's going to get boring very quickly.

I have the URLs of the pages though, so there must be a way of getting Excel to run off and get them for me (one score to one sheet)

This is one of the URLs:

http://www.oobgolf.com/golfers/score.php?id=2468974

The only part that changes is the ID number (so surprise there!). The two tables are the 'header' above the score table ('Date' etc.) and the score table itself.

JJ
[small][purple]Variables won't. Constants aren't[/purple]
There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)[/small]

 

[SkipVought]

Hi,

Turn on your macro recorded

Data > Get external data > Web... And drill down to your web site.

Use the mrker icons to select the data you want.

Since there's paging you'll see in the recorded code something like Page=1

You can assign page numbers in a loop.

 

[JPJeffery]

An obvious solution (by which I mean, why the HELL didn't I think of that!).



Thank you!

JJ
[small][purple]Variables won't. Constants aren't[/purple]
There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)[/small]

 

[SkipVought]

Post back with your code in forum707 if you have further questions.