External Data

[nextgenoctavius]

Howdy,
I just started tinkering with Excel's Web Query and have found it
to be quite nice. However I want to know if I can get it to do exactly
what I want. I want to be able to quickly set up new web queries. I
want to be able to pull from many pages off the web, but each site is
formatted identically. Effectively I want to have excel pull the same
table from a bunch of links that I can type out because the address is
pretty much straight forward ie:

www.bob.com/pg_1
www.bob.com/pg_2

and so on. If you could help it would be greatly appreciated. It's
just too hard to do it the long way of setting up each and every web
page individualy. Once again, thanks!

-Matthew Bowyer

 

[Don Guillett]

IF possible, it might help if you gave actual url's to see how this could be
done with a loop.

 

[nextgenoctavius]

http://football.fantasysports.yahoo...L&pos=O&cut_type=9&stat1=S_W_1&sort=3&count=0
http://football.fantasysports.yahoo...&pos=O&cut_type=9&stat1=S_W_1&sort=3&count=25
http://football.fantasysports.yahoo...L&pos=O&cut_type=9&stat1=S_W_2&sort=3&count=0
http://football.fantasysports.yahoo...&pos=O&cut_type=9&stat1=S_W_2&sort=3&count=25

Count needs to go from 0 to 200 by 25 and S_W_ needs to go from 1-17 by
1.

Thanks for the quick reply!

 

[Don Guillett]

I got this error message so
You are not allowed to view this page because you are not in this league.
(Error #152)
I can't test but

for i= 0 to 200 step 25
do stuff
next i

for ii=1 to 17
do stuff
next ii
=======
or

for i=1 to 5
sw=1
cc=0
myurl=http://football.fantasysports.yahoo.com/f1/75227/players?status=ALL&pos=O&cut_type=9&stat1=S_W_"&sw&"&sort=3&count="&cc&"
sw=sw+1
cc+25
next i