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

Matt
I and many others have exactly the same problem. It's to do with changes
made at Yahoo. See my other post on this topic. Their link has changed.
If you left click their download link it now loads the data into your
browser window rather than giving you the option of saving a CSV file. If
you right click you get an error. This error, which you get from within IE,
is also preventing web queries from working.

I have found this is quite Windows/browser version specific. It may depend
on the security patches applied to IE as well. With IE 5.1 I don't have
problems. With IE 6.0 with the latest security patches I now (as at a few
days ago) cannot get it to work.

Send a note to Yahoo -- it's definitly their service that's the problem. But
who knows whether it is something intentional on their part or whether it's
just a bug which they will fix.


"Matt Day" wrote in message
...
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

Is there a way to convert to an older version of IE?

Thanks

Matt
"Peter Benson" wrote in message
...
Matt
I and many others have exactly the same problem. It's to do with changes
made at Yahoo. See my other post on this topic. Their link has changed.
If you left click their download link it now loads the data into your
browser window rather than giving you the option of saving a CSV file. If
you right click you get an error. This error, which you get from within
IE,
is also preventing web queries from working.

I have found this is quite Windows/browser version specific. It may depend
on the security patches applied to IE as well. With IE 5.1 I don't have
problems. With IE 6.0 with the latest security patches I now (as at a few
days ago) cannot get it to work.

Send a note to Yahoo -- it's definitly their service that's the problem.
But
who knows whether it is something intentional on their part or whether
it's
just a bug which they will fix.


"Matt Day" wrote in message
...
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