Excel VB code: Opening Yahoo! webpages

[Nerfherders]

Not sure if this is the right forum but here goes.

I was given an excel spreadsheet that will extract stats on a daily basis. basically, it uses the following code:

Workbooks.Open filename:="http://standard.baseball.fantasysports.yahoo.com/b1/[league#]/standings"

Unfortunately this is returning a blank page. If I leave off the 'standings' part so it returns the main league page it works fine, but digging in past that returns blank. I'm thinking it has something to do with login but I'm logged into the Yahoo when I try it.

Can Anyone mildly familiar with VB in Excel help?

[Amazinz]

I tested it and it works fine for me. Two things I can think of: 1. Did you make sure [league#] is being set correctly? You can use Debug.Print to verify. 2. I am pretty sure that Excel uses IE's cookies so make sure you're logged in via IE and not Firefox or some other browser. Although I can't explain why you'd get a blank page since even when I logout or purposely provide bunk data I get a response from Yahoo.

[TEKTON]

how does on do this from excel. if anyone has the time to explain.
thanks in advance

[TEKTON]

nevermind i figured it out

[gostanford07]

Just out of curiosity, would this be able to work in H2H? It appears as if it's for roto, but I know absolutely nothing about excel. Is there any way to keep live stats/standings once the trial of stattracker has expired? Thanks guys.

[GrubNasty]

i had no dice as well... in that i got a blank page informing me i was not logged in....took the steps to log in under IE and still no dice....

is this because the league is set as private and not public?

[teddy ballgame]

I have Excel but I've never needed to use it before. If someone has a chance could they maybe make a walkthrough of how to do it?

[pope]

I have Excel but I've never needed to use it before. If someone has a chance could they maybe make a walkthrough of how to do it?

I would too love this!!!!!!!!!!!!!!!!!!!!!!!!!