web query returns no data
 

When I do a web query, no data is returned, but when I use the Internet
Explorer and go to the same page in it opens up the page with no
problem....It worked before...but not now...what could be the problem?

web query returns no data
 

How are you doing this? Post the url and your web query.
It could be as easy as changing the extension to .csv

--
Don Guillett
SalesAid Software

"Gary" wrote in message
...
When I do a web query, no data is returned, but when I use the Internet
Explorer and go to the same page in it opens up the page with no
problem....It worked before...but not now...what could be the problem?

web query returns no data
 

'I'm already logged in so there is no login erros

v =
"URL;http://baseball.fantasysports.yahoo.com/b1/338255/2/team?date=2006-04-12&stat1=S&stat2=S_2006"

QueryTables.Add(Connection:=v, Destination:=Range("AD1")).Refresh
BackgroundQuery = True



SalesAid Software

"Gary" wrote in message
...
When I do a web query, no data is returned, but when I use the Internet
Explorer and go to the same page in it opens up the page with no
problem....It worked before...but not now...what could be the problem?

web query returns no data
 

use

activesheet.QueryTables.Add(

--
Don Guillett
SalesAid Software

"Gary" wrote in message
...
'I'm already logged in so there is no login erros

v =
"URL;http://baseball.fantasysports.yahoo.com/b1/338255/2/team?date=2006-04-12&stat1=S&stat2=S_2006"

QueryTables.Add(Connection:=v, Destination:=Range("AD1")).Refresh
BackgroundQuery = True



SalesAid Software

"Gary" wrote in message
...
When I do a web query, no data is returned, but when I use the Internet
Explorer and go to the same page in it opens up the page with no
problem....It worked before...but not now...what could be the problem?

web query returns no data
 

the code is written in the sheet and it doesn't matter if I use activesheet.
or not...

"Don Guillett" wrote:

use

activesheet.QueryTables.Add(

--
Don Guillett
SalesAid Software

"Gary" wrote in message
...
'I'm already logged in so there is no login erros

v =
"URL;http://baseball.fantasysports.yahoo.com/b1/338255/2/team?date=2006-04-12&stat1=S&stat2=S_2006"

QueryTables.Add(Connection:=v, Destination:=Range("AD1")).Refresh
BackgroundQuery = True



SalesAid Software

"Gary" wrote in message
...
When I do a web query, no data is returned, but when I use the Internet
Explorer and go to the same page in it opens up the page with no
problem....It worked before...but not now...what could be the problem?

web query returns no data
 

Ok, if in the sheet module it didn't need that. I get this with xl2002.
Pos Batters Action Opp Status H/AB R HR RBI SB AVG
C B. Molina The add action is disabled Watch List is not available
@Bos 4:05 PM 16-Jul 2 1 2 0 0.438
(Tor - C)
1B J. Gibbons The add action is disabled Watch List is not available
@TB 4:15 PM 27-Oct 5 2 7 0 0.37
(Bal - 1B,OF)


--
Don Guillett
SalesAid Software

"Gary" wrote in message
...
the code is written in the sheet and it doesn't matter if I use
activesheet.
or not...

"Don Guillett" wrote:

use

activesheet.QueryTables.Add(

--
Don Guillett
SalesAid Software

"Gary" wrote in message
...
'I'm already logged in so there is no login erros

v =
"URL;http://baseball.fantasysports.yahoo.com/b1/338255/2/team?date=2006-04-12&stat1=S&stat2=S_2006"

QueryTables.Add(Connection:=v, Destination:=Range("AD1")).Refresh
BackgroundQuery = True



SalesAid Software

"Gary" wrote in message
...
When I do a web query, no data is returned, but when I use the
Internet
Explorer and go to the same page in it opens up the page with no
problem....It worked before...but not now...what could be the
problem?

web query returns no data
 

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