View Single Post
 
Old 07-01-2015, 01:32 PM
edneco edneco is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jun 2014
Posts: 12
edneco is on a distinguished road
Default VBA code to login a web site and extract data to excel

Hello everyone...

My knowledge of VBA code is very very limited. The only code I made is from recording some macros.... So you see what point I'am.....

I can get some data from websites trough Excel-> Data -> From Web and then pick the yellow boxes to import tables (when the sites allow it)..... In my specific case I need to import some data from this site: www.betbrain.com

I donīt know if you know this site. This site is about sports and betting. I want to import the odds from specific football leagues with some specific odds (Bet365)..... In my website preferences, when I login, the Bet365 odds are show in every match. If I donīt login, the odds that appear is the best odds we can bet.

So, I need to login with my username and password to get the odds I want and copy them to excel.

I donīt know either if is its possible to do what I want with VBA code. I hope it can......

In this link we have the Premier League (UK) games for the 1st round.

http://www.betbrain.com/football/eng...remier-league/


Thank you in advance for any help you can give me on this.......


Cheers, Eduardo


PS -> In the future Iīll need some help to "convert" this to a userform (like an application)......
Reply With Quote