Possible to use VBA to extract website data from multiple pages?

[Jonathanm3]

Any help on this would be greatly appreciated ...

I want to extract some data from a website of historic football odds data, I can do this easily for the 90 minutes market as all data is on one page, quick copy and paste, bit of text to columns magic and its job done.

Problem is that for other markets, such as Under/Over 2.5 Goals, you have to click into each match, taking you away from the main results page for the league.

This of course would make any data extraction very manual, but i was wondering if it would be possible through VBA?

Maybe get it to go into the data game by game, extract what is needed and then go back to the previous page, loop down to the next match and repeat?

I've used VBA to create user input forms and just general database things completely within excel but have never used it to link to explorer or anything.

Possible?

Thanks in advance

 

[Jonathanm3]

So here's a bit of an example:

The main page containing a whole season of results would be :
Ligue 1 2016/2017 Results & Historical Odds, Soccer France Archive

I would want the code to go to this page, and then select the first match, Lorient v Troyes, which has this code:

Lorient - Troyes Betting Odds, Soccer - Ligue 1 2016/2017

And then i would want it to select the O/U Tab, with this code:

Lorient - Troyes Betting Odds, Soccer - Ligue 1 2016/2017

Extract the Maximum odds values for Under and Over 2.5 Goals into excel, next to the fixture and then go back to:

[FONT=&quot]Ligue 1 2016/2017 Results & Historical Odds, Soccer France Archive

And repeat for the next match on the list....


[/FONT]
[FONT=&quot]
[/FONT]