| 0 |
Subject: extracting databases from yahoo!
Posted by: Nerfherders
- [501035289] Thu, Apr 06, 2006, 19:05
I had a VB macro in excel that could extract a database from the daily yahoo! rosters. now suddenly it returns nothing. I tried it on my CBSSportsline team and it works fine. Do you think Yahoo! has come up with a way to block excel from grabbing the daily stats? |
| 1 | Guru
ID: 330592710
Thu, Apr 06, 2006, 20:36
|
No. I'm doing it, using the same routines as in prior years.
|
| 2 | allhair allstars
Sustainer
ID: 50902421
Thu, Apr 06, 2006, 21:10
|
Ditto. No problems.
|
| 3 | Nerfherders
ID: 64532914
Mon, Apr 10, 2006, 13:36
|
Then my next question is what am I doing wrong? Can I get your VB macros somehow?
|
| 4 | Guru
ID: 330592710
Mon, Apr 10, 2006, 13:49
|
I use an excel macro which simply reads in a number of different league pages, yanks the stats, and does some processing. It works as long as I am simultaneously logged into my Yahoo ID (through my browser).
The statement to open a page is very simple:
Workbooks.Open Filename=:"http://baseball.fantasysports.yahoo.com/b1/nnnnnn/standings"
where nnnnnn is the league id number.
Nothing fancy.
|
| 5 | Nerfherders
ID: 64532914
Mon, Apr 10, 2006, 21:32
|
If either of you can email me your excel files I'd greatly appreciate it. I'm by no means a VB wiz. Thanks!
|
| 6 | Guru
ID: 330592710
Mon, Apr 10, 2006, 21:44
|
Spreadsheet emailed.
|
| 7 | Nerfherders
ID: 501035289
Wed, Apr 12, 2006, 13:18
|
I've been racking my brain trying to figure out why the spreadsheet code is returning blank pages. If I change the URL to anything in yahoo up to and including the main league page, it works. But if I dig into standings or rosters it returns blank. I'm logged into Yahoo in IE, but I'm wondering if there's a super-secret login I need to use or something.
|
| 8 | RecycledSpinalFluid
Dude
ID: 204401122
Wed, Apr 12, 2006, 14:00
|
I think Guru releases the super secret logon code to you once you reach "sustainer" on the GuruPatron Plan.
|
| 10 | Guru
ID: 330592710
Wed, Apr 12, 2006, 14:51
|
Try clearing your cache. Sometimes excel is very willing to keep pulling a page from the cache instead of fetching it directly from the server.
|
| 11 | Nerfherders
ID: 501035289
Wed, Apr 12, 2006, 17:02
|
I tried clearing the cache, I lowered the privacy settings to accept more cookies. Nothing seems to work. I use Firefox and Im guessing that has something to do with it, even though Ive gone so far to reboot the machine and open IE instead of Firefox. They both share the same cookies.
I think now it's more I want to know why it doesnt work for me while working for at least 3 other people. It's very strange!
|
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|