Excel VB code: Opening Yahoo! webpages - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

Excel VB code: Opening Yahoo! webpages

Moderator: Baseball Moderators

Excel VB code: Opening Yahoo! webpages

Postby Nerfherders » Wed Apr 12, 2006 3:13 pm

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?
Nerfherders
Minor League Mentor
Minor League Mentor

User avatar
Cafe Writer
Posts: 668
(Past Year: 4)
Joined: 25 Jun 2004
Home Cafe: Baseball

Postby Amazinz » Wed Apr 12, 2006 3:43 pm

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.
Image
Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Postby TEKTON » Wed Apr 12, 2006 7:15 pm

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

User avatar

Posts: 197
Joined: 29 Mar 2004
Home Cafe: Baseball

Postby TEKTON » Wed Apr 12, 2006 7:21 pm

nevermind i figured it out
TEKTON
College Coach
College Coach

User avatar

Posts: 197
Joined: 29 Mar 2004
Home Cafe: Baseball

Postby gostanford07 » Wed Apr 12, 2006 8:43 pm

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.
Image
gostanford07
Minor League Mentor
Minor League Mentor

User avatar
Eagle Eye
Posts: 546
Joined: 23 Feb 2005
Home Cafe: Baseball
Location: 707... The home of Jonny Gomes and Jason Lane

Postby GrubNasty » Wed Apr 12, 2006 10:44 pm

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?
GrubNasty
College Coach
College Coach


Posts: 310
Joined: 17 Nov 2005
Home Cafe: Basketball

Postby teddy ballgame » Sat Apr 15, 2006 3:00 pm

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? :-o
Image
teddy ballgame
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterCafe RankerGraphics ExpertMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 11485
Joined: 7 Feb 2006
Home Cafe: Baseball
Location: Beantown

Postby pope » Sat Apr 15, 2006 5:00 pm

teddy ballgame wrote: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? :-o



I would too love this!!!!!!!!!!!!!!!!!!!!!!!!! ;-D
pope
College Coach
College Coach

User avatar

Posts: 210
Joined: 13 Mar 2006
Home Cafe: Baseball
Location: On a Highway To Hell


Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 10 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Saturday, Jul. 26
(All times are EST, weather icons show forecast for game time)

Toronto at NY Yankees
(1:05 pm)
St. Louis at Chi Cubs
(4:05 pm)
Washington at Cincinnati
(4:05 pm)
Baltimore at Seattle
(4:10 pm)
Arizona at Philadelphia
(7:05 pm)
Boston at Tampa Bay
(7:10 pm)
indoors
Chi White Sox at Minnesota
(7:10 pm)
NY Mets at Milwaukee
(7:10 pm)
Cleveland at Kansas City
(7:10 pm)
Miami at Houston
(7:10 pm)
San Diego at Atlanta
(7:10 pm)
Oakland at Texas
(8:05 pm)
Pittsburgh at Colorado
(8:10 pm)
Detroit at LA Angels
(9:05 pm)
LA Dodgers at San Francisco
(9:05 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact