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
 

Thread Tools
Display Modes


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 05:29 PM.


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