Macro to extract table data from website into my excel file
Hi.
I am trying to construct a MACRO that will get data from a WEBSITE and put it to my excel file. But, that table data from website has 3 option (team, year and date) and want fisrt to ask me what years and what day before copying table and paste (as text) into my excel file.
I am using excel 2003.
Here is the link from where i want to extract data : http://www.statto.com/football/stats...011-2012/table
Hi,
Run your browser and change the league and date manually and see the URL change.
Then in your code change the URL string you use in your VBA to open the page.
See if that helps.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Here is how my macro looks like:
Copy data from URL corectly, but when paste change scores (0-3) into DATE format
Please Login or Register to view this content.
Last edited by JBeaucaire; 12-31-2012 at 02:24 AM. Reason: Added code tags, as per forum rules. Don't forget!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks