View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kanind kanind is offline
external usenet poster
 
Posts: 3
Default Webquery - Excel 2003

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.