Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
page setup query | Excel Discussion (Misc queries) | |||
Page Break bug update query | Excel Programming | |||
How can I use web query with a password protected page? | Excel Programming | |||
Making a query from a web page using VBA. | Excel Programming | |||
query page with javascript | Excel Programming |