RE: Yahoo quotes error in Excel

From: Sonny Kocak[MSFT] (a-sonnyk_at_online.microsoft.com)
Date: 02/10/04 

Date: Tue, 10 Feb 2004 14:39:13 GMT

Dear Peter ,

Thank you for contacting Microsoft Excel Online Support. My name is Sonny
and I will
be assisting you with this issue.

It clearly appears that you understand that the whole issue is the lack of
the CSV file. Thus, I can not speculate to Yahoo behavior on this manner.
However, I can offer some helpful suggestions. One needs to ask: does this
happen for each stock? Does it happen only for my existing stock list? Do I
need to rebuild my list? Does this occur on new stock that I haven't tried?
Is the problem isolated to just this machine?

Finally, It appears that Yahoo Finance web site still supports and provides
downloadable stock files for spreadsheets. I am including two links below
to Yahoo support pages: The first is for problems with downloadable
spread***. (NOTE: with special instructions for Netscape 4.0 users). The
second link is general finance support.

1) http://help.yahoo.com/help/us/fin/quote/quote-05.html

2) http://help.yahoo.com/help/us/fin/quote/

Hope this helps,

Sonny Kocak
Microsoft Developer Support Professional
This pointing is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: "Peter Benson" <junk@junk.com>
| Subject: Yahoo quotes error in Excel
| Date: Tue, 10 Feb 2004 23:16:17 +1100
| Lines: 14
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <e0dW2#87DHA.2472@TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.excel.programming
| NNTP-Posting-Host: cpe-144-132-167-133.nsw.bigpond.net.au 144.132.167.133
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.excel.programming:461562
| X-Tomcat-NG: microsoft.public.excel.programming
|
| For those of you who have recently been getting "Application-defined or
| object-defined error" when attepting to get a quote from Yahoo from Exce
| VBA: their US site http://finance.yahoo.com/?u currently won't let you
| download a CSV file. eg get a quote for IBM and click the "download data"
| link. As at today it simply displays the data in your browser window
rather
| than letting you download the data in CSV format like it used to. Over the
| last month the problem was intermittent but now it seems to be constant.
As
| no CSV file is downloaded Excel displays the Application-defined or object
| defined error.
|
| I have no idea whether the problem with Yahoo is temporary or permanent.
|
|
|
|