Why do I have to restart Excel when ActiveSheet.QueryTables.Add fails?

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

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 are:
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
 
Hi there,
I have exactly the same problem as you. When my macro crashes on
ActiveSheet.QueryTables.Add, I have to restart Excel to get it to work. Did you figure out a way around this?

Thanks
 
Back
Top