Disable error msg "Unable to open..." web query

[Mulkis]

Hi,
I am using web queries extensively and ocassionally getting messages "Unable to open http: // www...... Cannot locate the internet server or proxy server."

I would like to disable this error poping-up because it freezes all other open queries until I hit ok.

I need something like On Error Resume Next. But I dont now whereto put it. Maybe somewhere in the registry????

Please help!

 

[Mulkis]

No answer so far...

Ok, in case anybody has the same problem, this is my solution how to overcome this: instead of using excel built-in web query refresh function, I've made custom refresh OnTime procedure with On Error Resume Next code included. Now my query updates as usual except it ignores any occasional connection problems.

PS. But now as everyone using OnTime event I face a problem, how to terminate it, but this is another issue

PS2. BTW by using custom made refresh one could make web query refreshing more frequently than excel 1 min limit -simply start several refresh procedures simultaneously.