My methods are fine and have been in use for years. Your stock getter
retrieves historical prices from what I see. This is a completely different
service from on-line quotes and still works fine.

You can see the quote service on Yahoo no longer lets you download a file:
go to the US Yahoo finance page, get a quote for a stock, press the
'download data' button and instead of downloading a file it now simply
displays the CSV contents in a web page. Unfortunately you cannot do a web
query on this web page as they are clearly doing some sort of redirection
which prevents using a simple web query from Excel.


"KJTFS " wrote in message
...
You might want to check you methods, my stock data getter at
www.kjtfs.com still works and I use Yahoo finance.

Keith
www.kjtfs.com

Peter Benson wrote:
*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. *


---
Message posted from http://www.ExcelForum.com/