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?
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?
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
[email protected]
"Gary" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>
'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
> [email protected]
> "Gary" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
> >
> >
>
>
>
use
activesheet.QueryTables.Add(
--
Don Guillett
SalesAid Software
[email protected]
"Gary" <[email protected]> wrote in message
news:[email protected]...
> '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
>> [email protected]
>> "Gary" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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?
>> >
>> >
>>
>>
>>
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
> [email protected]
> "Gary" <[email protected]> wrote in message
> news:[email protected]...
> > '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
> >> [email protected]
> >> "Gary" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > 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?
> >> >
> >> >
> >>
> >>
> >>
>
>
>
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
[email protected]
"Gary" <[email protected]> wrote in message
news:[email protected]...
> 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
>> [email protected]
>> "Gary" <[email protected]> wrote in message
>> news:[email protected]...
>> > '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
>> >> [email protected]
>> >> "Gary" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> > 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?
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks