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: 7
Default Web Query

Hello,

I have a web query embedded within a spreadsheet that up until recently was
working just fine. It goes out to Yahoo's website and grabs financial data
in .csv format and brings it back to the spreadsheet. This macro and
connection works fine for others as well as for me at work, but at home I am
getting an error message stating that the connection was made but the data
was not available. This seems to be related to either my computer or my
internet connection. I am currently on Comcast High Speed Internet at home,
but others are able to use their cable internet as well as T1 lines to
access the info. It will even work on a dial up connection. Does anyone have
an idea as to why this could be happening?

I have tried power cycling my cable modem to acquire a new connection but
that does not seem to help. The interesting thing is that up until today I
was able to eventually get the macro to grab the data from the website, but
it took many tries. Tonight I am not able to grab the data at all. Even if I
try to right click on the cell in the spreadsheet and attempt to just
refresh the query, it says:

Unable to open. http://finance.yahoo.com/d/quotes.csv?s=.....=.csv

and that the internet site reports that a connection was made but the data
was not available.

Suggestions would be greatly appreciated. I have no idea what would have
caused this or why it started.

Thanks

Matt


 
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
Use MS Query to query data within the current work book Steve Kesler Excel Discussion (Misc queries) 0 August 6th 09 05:22 PM
Convert hard coded query criteria to Parameter Query Melanie[_2_] Excel Discussion (Misc queries) 0 July 15th 08 09:59 PM
Excel 2007 / MS Query - editing existing query to another sheet Hotpepperz Excel Discussion (Misc queries) 0 June 13th 08 06:53 PM
Importing Data via Web Query - Can values be passed to query? [email protected] Excel Discussion (Misc queries) 5 May 9th 06 06:21 PM
Microsoft Query rejects "nz" function in Access Query Vaughan Excel Discussion (Misc queries) 0 May 4th 05 05:20 PM


All times are GMT +1. The time now is 06:44 PM.

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"