Downloading Yahoo spreadsheet

[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!

 

[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.

 

[Don Guillett]

I had the same problem with my .csv method. So, I will need to re-write for
my list but this will work temporairly.

MyURL = "http://finance.yahoo.com/q/cq?d=v1&s=ibm,msft,t"

 

[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.

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...

 

[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!

From: (e-mail address removed)

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

 

[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!

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

 

[Guest]

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???

 

[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
(e-mail address removed)

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???