LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 273
Default Cant query a web page

I am using Excel 2000....using the same querytables function i can get just
about any page to come up......

For some reason a page that will come up in the Internet explorer will
return no data when I perform the function....

Can anyone tell me why the page returns no data even thought the web page
exists?

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 returns no data even though the page exists

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
page setup query hsg Excel Discussion (Misc queries) 0 March 17th 06 07:28 PM
Page Break bug update query Otto Moehrbach Excel Programming 4 July 25th 05 07:46 PM
How can I use web query with a password protected page? claytorm[_3_] Excel Programming 6 August 22nd 04 08:39 PM
Making a query from a web page using VBA. Dan[_34_] Excel Programming 1 April 29th 04 09:52 PM
query page with javascript Rhonda[_2_] Excel Programming 0 September 23rd 03 10:57 AM


All times are GMT +1. The time now is 05:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"