At a guess, firewall or something to do with your internet connection.

NickHK

"kanind" wrote in message
...
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.financ
e.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.