Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
maximum as to the csv data that can be downloaded in to Excel
Hello,
When I run a query to download some stock data from Yahoo, (see code below), I get " Run-time error '1004' An unexpected error has occurred. I hit "debug" and "Refresh BackgroundQuery:=False" is highlighted. This does not happen if there are few symbols but if there are many symbols I get this error. Is there a maximum as to the csv data that can be downloaded into Excel? Is there some code I can add to avoid this error? With Sheets("sheet1").QueryTables.Add(Connection:="URL; " _ & "http://finance.yahoo.com/d/quotes.csv?s=" & _ symbols & "&f=sn11&e=.csv", _ Destination:=Sheets("sheet1").Range("b3")) .BackgroundQuery = True .TablesOnlyFromHTML = False .Refresh BackgroundQuery:=False .SaveData = True End With Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing part(s) of text from downloaded data | Excel Worksheet Functions | |||
Apostrophe In Data Downloaded | Excel Discussion (Misc queries) | |||
Data downloaded with green triangle(indentation) | Excel Worksheet Functions | |||
How do I eliminate leading zeros from downloaded data? | Excel Worksheet Functions | |||
how read data downloaded on cd-rw, now show only code? | New Users to Excel |