Downloading Yahoo spreadsheet

S

Steve

For years I've been downloading spreadsheets from Yahoo's stock
listings and using them in Excel. But lately, when I right-click
Download Spreadsheet and click Save Target As, I get message:

"IE cannot download .....csv from finance.yahoo.com. The requested
site is either unavailable or cannot be found."

I'm using IE6 under WinXP. Any ideas? Thanks!
 
D

Don Guillett

You didn't tell us how you are doing this and what version of excel. But, it
could be as simple as adding .html to the end of your url.
 
S

Steve

You didn't tell us how you are doing this and what version of excel. But, it
could be as simple as adding .html to the end of your url.
Click to expand...

I go to my portfolio list at Yahoo and right-click Download
Spreadsheet, then click Save Target As. This procedure has worked
fine up until the last few weeks...
 
S

Steve

Steve said:
For years I've been downloading spreadsheets from Yahoo's stock
listings and using them in Excel. But lately, when I right-click
Download Spreadsheet and click Save Target As, I get message:
"IE cannot download .....csv from finance.yahoo.com. The requested
site is either unavailable or cannot be found."
I'm using IE6 under WinXP. Any ideas? Thanks!
Click to expand...


From: [email protected]

Thank you for reporting this problem. We have alerted our engineering
and production staff and hope to have a solution in place shortly.
 
S

Steve

Steve said:
For years I've been downloading spreadsheets from Yahoo's stock
listings and using them in Excel. But lately, when I right-click
Download Spreadsheet and click Save Target As, I get message:
"IE cannot download .....csv from finance.yahoo.com. The requested
site is either unavailable or cannot be found."
I'm using IE6 under WinXP. Any ideas? Thanks!
Click to expand...

Just tried it using Netscape, works fine. Betcha this has something
to do with one of Microsoft's critical updates...
 
J

Jim

I have been doing the same, but left clicking the download spreadsheet, then simply printing a hard copy print every day. Now, ever since Feb 10th, my tracks do not come up in excel format; I've just downloaded every single update to excel and office and windows (xp pro, office xp), and I still get the same problem; yet on my old laptop running older versions it still comes up fine. Ergo, could be something to do with the updates???
 
D

Don Guillett

Here is a simple query macro you can use. It is a small part of a custom
program I design for clients. In this form it would need work but it will do
the job for you to download intoan excel workbook.

Sub simpleone()
MyURL = "http://finance.yahoo.com/q/cq?d=v1&s=ibm,t,fe"
With Sheets("Sheet4").QueryTables.Add(Connection:="URL;" & MyURL, _
Destination:=Sheets("Sheet4").Range("b2"))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub

--
Don Guillett
SalesAid Software
[email protected]
Jim said:
I have been doing the same, but left clicking the download spreadsheet,
Click to expand...
then simply printing a hard copy print every day. Now, ever since Feb 10th,
my tracks do not come up in excel format; I've just downloaded every single
update to excel and office and windows (xp pro, office xp), and I still get
the same problem; yet on my old laptop running older versions it still comes
up fine. Ergo, could be something to do with the updates???
 
Top