Hi,

I am looking for some fancy code that would import data from a
specific site from mutiple pages from within the site. I recorded one
page using the macro recorder, then I went into the code and
manipulated it somewhat, but it is still too manual and to combursome
to work with from a practical point of view.

- The site is www.covers.com
- I want to downlaod all past scorer results for each NCAAB team.
- All the teams can be found at:

http://www.covers.com/pageLoader/pag...ams/teams.html

- There are over 300 teams.
- Each team has a specific page which shows a specific year's results.
I beleive it currently goes as far back as the 1997-1998 season. So
that at least 10 pages per team.

Example of 1 team for a specific year:

http://www.covers.com/pageLoader/pag.../team2518.html

- Ideally I would like a macro to import 50 teams at a time using
their specific team codes to identify the teams. Duke for example =
2518. So I would need an option to enter in the team # first, or if
it's too much code, I can go into the code itself and change it
manually. Output would be the page data + the last cell of each row
would contain the name of the team.

Thanks you.