Web Query: how to avoid IE script error?

Question

Moderators:  Please do not move this thread without discussing with me first in PM.

When I do a Web Query, I get an IE script error after selecting a table and pressing Import.

How can I avoid that?

In a new workbook, I click on Data, Get External Data, From Web.

Then I enter http://finance.yahoo.com/q/hp?a=00&b=2&c=1962&d=08&e=21&f=2013&g=d&s=^gspc&ql=1 into the Address field and click on Go.

Then I select the arrow to the left of Date in the price table, and click on Import.

I get the following pop-up:

I do not get that error when I access the web page using IE directly.  But then again, I am not doing anything to access the price table directly.

Of course, I simply click on No and proceed with the import.

But is there some way that I can avoid the nuisance?

---

When I tested the recorded macro, I did not get that error.

But I worry that it might be something that I need to guard against.

I am not sure if Application.DisableAlerts=False would do the trick, since I cannot duplicate the error programmatically.  I doubt that it is does.

Answer 1

Does anyone see a similar problem when you do this Web Query manually?

http://finance.yahoo.com/q/hp?a=00&b=2&c=1962&d=08&e=21&f=2013&g=d&s=^gspc&ql=1

Does anyone not see a similar problem?

Answer 2

This is so frustrating. I'm getting the same script error. If anyone knows how to fix this please post solution.