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?