Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-01-2015, 01:32 PM
edneco edneco is offline VBA code to login a web site and extract data to excel Windows 7 32bit VBA code to login a web site and extract data to excel Office 2007
Novice
VBA code to login a web site and extract data to excel
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Require assistance in writing code to login to webmail account. saurabhlotankar Excel Programming 4 05-21-2015 10:47 AM
VBA code to login a web site and extract data to excel Extract Excel Data from Chart in Word cillianmccolgan Word 1 08-15-2014 01:42 AM
VBA code to login a web site and extract data to excel How to extract data from Excel database to create word report for each patient (row) nightale Word 3 07-06-2014 04:17 PM
Macro to login to horseracebase.com web site and download today cards file Catalin.B Excel Programming 3 10-20-2013 10:02 AM
Extract Numbers from Zip Code Karen615 Excel 3 09-21-2011 06:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:17 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft