Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sporadic web query failure
Hi!
I have a workbook that contains a web query. Lately, however, this query has been failing on occasions. Sometimes it works perfectly, but at other times (often within minutes) it stays stuck. I have precisely the same problem with a VBA procedure that opens a workbook which is on the internet. The procedure is simply workbooks.open("http://www.blah.com/blah.xls") It works sometimes, but sometimes it gets stuck. I can't really tell what event may have triggered the occasional failures. The only thing that comes to mind is the recent installation of IE8. Other than that there have been no major changes to my machine... Any advice on what to do? Thanks in advance, Albert C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup failure & ctrl-f failure? | Excel Discussion (Misc queries) | |||
failure of web query | Excel Discussion (Misc queries) | |||
delete blanks - sporadic | Excel Discussion (Misc queries) | |||
"Web Query" refresh failure | Excel Discussion (Misc queries) | |||
Sporadic Problems opening TDF in 2003 | Excel Discussion (Misc queries) |