Retrieving Web Query Data

[sagar]

Hi folks,

I developed a web query to get data from an odd comparison website. Everything works fine but sometimes I receive a message saying "Unable to open the web page...". This happens when for some reason there is an interruption of the Internet connection. The problem is that until I click OK on the error message Excel is completely stuck. This is fine if I'm in front of the computer but if I'm not then Excel can remain unactive for hours. Is there anyone who had the same sort of problem? If so, how did you solve it?

Thanks!
S.

[osknows]

Is it a run-time error '1004', Unable to open http://www..... etc?

If it is then you can do something similar to this in VBA

Code: Select all

On error resume next
'code to refresh web query goes here
On error goto 0

[sagar]

Hi, thanks for the reply. No, it's not a run-time error '1004' and actually I'm not calling the web query through VBA but just though Excel. It's just a message that pops up saying 'Unable to open the web page' or something like that followed but the web address. It's very annoying because Excel gets stuck until I click on 'OK'.
Maybe I should call the web query through VBA?

Thanks for your help!
S.

Is it a run-time error '1004', Unable to open http://www..... etc?

If it is then you can do something similar to this in VBA

Code: Select all

On error resume next
'code to refresh web query goes here
On error goto 0