Web Query - Import data from multiple pages into a single MS Excel worksheet.

If a website contains data in a single page, we can extract the same using Excel 2007 'import from web' feature under 'data' button. Can we do the same if the data runs to several pages ? Example. I want to know the cricket scores of various batsmen, match-wise and Cricinfo gives the same in 55 pages under the following URLs:

ODI Batting
Page1
http://stats.espncricinfo.com/ci/eng...ppertype=print
Page 2
http://stats.espncricinfo.com/ci/eng...ppertype=print
Page 3
http://stats.espncricinfo.com/ci/eng...ppertype=print
Page 55
http://stats.espncricinfo.com/ci/eng...ppertype=print
How do I take such a huge data into a single excel sheet ?
Thanks for help. I am learning excel.

Please include URL; in the Curl Variable before the exact URL. Plus, also supply

Please Login or Register  to view this content.

instead of just Range.

Worked for me.

Thanks,
Vikas B

PS, always use code tags whenever you post any code in the forum.

Thanks, my friend. It has worked. I am learning macros.

Couple of issues in the above examples:

1) when the first macro is run, it generated 10,978 rows. But when the second macro is run, it generated 11,110 rows. I feel both of them should have same number of rows. Is there a flaw in these macros ?

2) Macros are unable to generate one continuous excel sheet. Each part of data is separated by a row containing a first cell (such as A1) having the word "Innings by Innings list". The next row again is a blank row with titles appearing (such as player, etc). Can we eliminate rows containing these two words so that all the data will appear in one range ?

On close observation of data I got, I see that all the sheets have not been imported. Surprised. Any problem in the code ?

Working fine but pages not contain the internal link