Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Downloading stock data
Help,
The follow code runs great in Windows 2000 and Excel 2000. I can download data for over 3000 stocks in less than 3 seconds. But it doesnt run at all in Vista 64 bit and Excel 2007. It errors out in the €ś .Refresh BackgroundQuery:=True €ś line with a €śRun time error 1004 An unexpected error has occurred€ť message. I wasnt expected it, so I guess it really is unexpected! CODE Set AllStockDataWorksheet = Workbooks(1).Worksheets(2) Set AllStockDataResults = AllStockDataWorksheet.QueryTables _ .Add(Connection:="URL;http://finance.yahoo.com/d/quotes.csv?s=" & Left(SymbolString, Len(SymbolString) - 1) & "&f=l1va2&e=.csv", _ Destination:=AllStockDataWorksheet.Cells(RowNumber , 51)) With AllStockDataResults .Refresh BackgroundQuery:=True End With Any help will be appreciated. Duane |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Downloading stock data
This doesn't look right
.Refresh BackgroundQuery:=True Comment out BackgroundQuery:=True Unless you need the query to always constantly update in the background include .Refresh BackgroundQuery:=False Regards, Peter T "Duane" wrote in message ... Help, The follow code runs great in Windows 2000 and Excel 2000. I can download data for over 3000 stocks in less than 3 seconds. But it doesn't run at all in Vista 64 bit and Excel 2007. It errors out in the " .Refresh BackgroundQuery:=True " line with a "Run time error 1004 An unexpected error has occurred" message. I wasn't expected it, so I guess it really is unexpected! CODE Set AllStockDataWorksheet = Workbooks(1).Worksheets(2) Set AllStockDataResults = AllStockDataWorksheet.QueryTables _ .Add(Connection:="URL;http://finance.yahoo.com/d/quotes.csv?s=" & Left(SymbolString, Len(SymbolString) - 1) & "&f=l1va2&e=.csv", _ Destination:=AllStockDataWorksheet.Cells(RowNumber , 51)) With AllStockDataResults .Refresh BackgroundQuery:=True End With Any help will be appreciated. Duane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Downloading stock prices automatically | New Users to Excel | |||
Downloading Stock Quotes | Excel Worksheet Functions | |||
Downloading historical stock data from MSN Money to Excel via VBA | Excel Programming | |||
downloading data | Excel Programming | |||
Downloading stock prices | Excel Programming |