That's what I am trying to get.....

I am using Excel 2000....using the same querytables function i can get just
about any page to come up......I can even get the yahoo page to come up until
I get to this part:

http://baseball.fantasysports.yahoo.com/b1/338255/2

examples:

'This works fine

Sub Test1()
v = "URL;http://baseball.fantasysports.yahoo.com/b1/338255"
QueryTables.Add(Connection:=v, Destination:=Range("AD1")).Refresh
'BackgroundQuery = True
End Sub

'This doesn't work at all

Sub Test2()
v = "URL;http://baseball.fantasysports.yahoo.com/b1/338255/2"
QueryTables.Add(Connection:=v, Destination:=Range("AD1")).Refresh
'BackgroundQuery = True
End Sub