So that you know, I’ve looked on various fora but except for the fact
that Excel 2007 seems not to have this problem, I could not find an
answer for previous versions of Excel.

Here is my query:

With ActiveSheet.QueryTables.Add(Connection:="TEXT;http ://
ichart.finance.yahoo.com/table.csv?s=msft&ignore=.csv",
Destination:=Range("A1"))
.RefreshStyle = xlOverwriteCells
.TextFileCommaDelimiter = True
.TextFileColumnDataTypes = Array(1, 9, 9, 9, 1, 9, 9)
.Refresh BackgroundQuery:=False
End With

Obviously BLABLABLA is not a valid ticker symbol but occasionally,
even with a valid ticker symbol, the query fails, for example, if
Yahoo! Finance website or the internet connection is down.

Once a query fails, I need to shut Excel down to start a valid query.

I cannot verify that the problem does not occur with Excel 2007 (I
still use 2003).

My questions a
Does having 2007 solve the problem?
Is there a workaround for previous versions of Excel?

Thanks

ooops. My query was supposed to read:

ActiveSheet.QueryTables.Add(Connection:="TEXT;http ://
ichart.finance.yahoo.com/table.csv?s=BLABLABLA&ignore=.csv",
Destination:=Range("A1"))

MSFT is a valid ticker symbol





On Nov 23, 8:07*am, Frank wrote:
So that you know, I’ve looked on various fora but except for the fact
that Excel 2007 seems not to have this problem, I could not find an
answer for previous versions of Excel.

Here is my query:

With ActiveSheet.QueryTables.Add(Connection:="TEXT;http ://
ichart.finance.yahoo.com/table.csv?s=msft&ignore=.csv",
Destination:=Range("A1"))
* * .RefreshStyle = xlOverwriteCells
* * .TextFileCommaDelimiter = True
* * .TextFileColumnDataTypes = Array(1, 9, 9, 9, 1, 9, 9)
* * .Refresh BackgroundQuery:=False
End With

Obviously BLABLABLA is not a valid ticker symbol but occasionally,
even with a valid ticker symbol, the query fails, for example, if
Yahoo! Finance website or the internet connection is down.

Once a query fails, I need to shut Excel down to start a valid query.

I cannot verify that the problem does not occur with Excel 2007 (I
still use 2003).

My questions a
Does having 2007 solve the problem?
Is there a workaround for previous versions of Excel?

Thanks