I have asked this same question elsewhere on the forum, but thggought I would start a new thread.
Hello,
I have been searching for a solution to my Dynamic Web Query for nearly 12 months, this thread is as best as it can get to describe a similar problem I can identify with.
Here’s what happens with my version of things.
It happens on both Excel Office 2000 and 2003
Same issue on 2 different computers, both running XP Pro.
The code I use is:
Sub getmyinfo ()
Do Until _
Sheets(“Sheet5”).Range(“D4”).Value = “Apples” Or Sheets(“Sheet5”).Range(“D9”).Value = “Oranges”
On Error GoTo notfound
With Selection.QueryTable
.Connection = “URL;http://mywebaddress.com.au/” & Sheets(“Sheet5”).Range(“A1”) & “.html”
.WebSelectionType = xlAllTables
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.Refresh BackgroundQuery:=False
End With
‘Code
Loop
‘Code
End sub
After 20 – 30 minutes it will stop.
If I F8, it will hi-Lite VBA code in yellow, but VBA will not respond.
At times I was not able to use any cells in any sheets.
I have upgraded Office with the latest patch releases etc, still the same problem occur
But it goes another “dimension” worse than I have read here.
When it happens;
I can close the workbook, or 2 workbooks because I have tried using a seperate workbook just for the web query to see if it could be solved.
Nothing seems to work still if I re-open the workbook, Excel has to be shutdown entirely.
An Error messsage will say,
“Cannot shut down Excel”
The only way to shutdown Excel is from the task manager using Cntrl/Alt/Dlete.
I then can run the macro again, for another 20 minutes, then all of a sudden it will freeze up again and manually do the same routine as described above.
I have tried much of what I have read here, including no AV or FW.
I have tried on a HD with Office installed only and still the same.
How can I solve this problem please ?
If need be I can post the exact web page, but I don’t think that might be important.
I feel the problem is Windows related.