So I did the data from web files thing and I put the website in and it comes up with the code below for the script. It works fine, the only problem is that this web page only has 100 listings. To get to the next 100, you have to go to the next page. The URL is the exact same except that the "200" in the URL becomes "300". I could just copy and paste this 50 times and keep changing the number, but I'm certain there is a better way of doing this. I'm pretty clueless when it comes to the script so any help would be appreciated.
LOAD Rank, Region, Character, Points, Wins, Losses, Ratio, Division, Age FROM [http://www.sc2ranks.com/ranks/all/diamond/1/all/points/200] (html, codepage is 1252, embedded labels, table is @1);
you can use a for ... next with a variable like this:
for vCounter=100 to 1200 step 100 Tbl: LOAD Rank, Region, Character, Points, Wins, Losses, Ratio, Division, Age FROM [http://www.sc2ranks.com/ranks/all/diamond/1/all/points/$(vCounter)] (html, codepage is 1252, embedded labels, table is @1); next;