Excel, VBA, Websites

Clauric

I was hoping somebody here might have a faster and automatic way of completing this task.

There is a website that provides a comprehensive list of English soccer/football results from about 1886 to the present day, for every team that has played in an English FA sponsored competition. As you can imagine this is a fairly massive database, and it is presented in various formats.

The format I'm interested is in the season format.

Basically, what I have got to start with is a list of teams, whose results I want, in column A of an Excel spreadsheet (call it Sheet 1), and in column B I have a list of years from 1886 to the present.

I am not sure if is possible, but what I am looking for is a VBA program that could take the information from Column A and Column B an input it into the web address, and take the table on the screen and input it into a spreadsheet (one spreadsheet per team, from start season to present day).

The wed address format is:

http://www.11v11.com/teams/(TEAM_Name_1)-(TEAM_NAME_2)-(TEAM_NAME_3-if-applicable)/tab/matches/season/(SEASON).

An example would be:

http://www.11v11.com/teams/manchester-united/tab/matches/season/2014

(where TEAM_NAME_1 is Manchester, TEAM_Name_2 is United, and Season is 2014.

Is this possible? If it is, could somebody provide me with a code (my VBA skills are near 0)?

Thanks,

Clauric

ObeyTheSuit

I'm getting the 404's bro.

Graham

Clauric wrote: »

I was hoping somebody here might have a faster and automatic way of completing this task.

There is a website that provides a comprehensive list of English soccer/football results from about 1886 to the present day, for every team that has played in an English FA sponsored competition. As you can imagine this is a fairly massive database, and it is presented in various formats.

The format I'm interested is in the season format.

Basically, what I have got to start with is a list of teams, whose results I want, in column A of an Excel spreadsheet (call it Sheet 1), and in column B I have a list of years from 1886 to the present.

I am not sure if is possible, but what I am looking for is a VBA program that could take the information from Column A and Column B an input it into the web address, and take the table on the screen and input it into a spreadsheet (one spreadsheet per team, from start season to present day).

The wed address format is:

http://www.11v11.com/teams/(TEAM_Name_1)-(TEAM_NAME_2)-(TEAM_NAME_3-if-applicable)/tab/matches/season/(SEASON).

An example would be:

http://www.11v11.com/teams/manchester-united/tab/matches/season/2014

(where TEAM_NAME_1 is Manchester, TEAM_Name_2 is United, and Season is 2014.

Is this possible? If it is, could somebody provide me with a code (my VBA skills are near 0)?

Thanks,

Clauric

What you're describing is data scraping and although it's possible to do that with VBA, it's probably not the best tool for someone with zero VBA skills.

I'd recommend you either go and pay somebody to write it for you (plenty of freelancer sites out there) or consider an alternative approach. Something like http://import.io may be easier for you.

Clauric

ObeyTheSuit wrote: »

I'm getting the 404's bro.

Seems like part of the website is down ATM.