Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the following script to get the stock quote from yahoo financial
website. This script works fine in my office PC but the same script returns Run-time error '1004' in my home PC. Both the places I am using Excel 2003 SP2 and Windows XP Professional Version 2002 Service Pack 2: Sub GetStockQuotes() With ActiveWorkbook.ActiveSheet.QueryTables.Add(Connect ion:="URL;http://in.finance.yahoo.com/d/quotes.csv?s=ASHOKLEY.NS&f=l1", Destination:=ActiveSheet.Cells(1, 1)) .BackgroundQuery = True .TablesOnlyFromHTML = False .Refresh BackgroundQuery:=False .SaveData = True End With End Sub Please advice me how to get rid of the Error. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Webquery | Excel Worksheet Functions | |||
Excel 2000 webquery fails for pages greater than 2k | Excel Programming | |||
Webquery datafield naming changed between excel versions 97 and 20 | Excel Programming | |||
Webquery | Excel Discussion (Misc queries) | |||
Using Webquery via VBA | Excel Programming |