Hi! Recently I created a VBA Macro which automatically adds web query tables into a worksheet. I have about 100+ of them in a worksheet and it loops by itself once I run the macro.
And the problem is that once in a while it just paused at one of the query for a long time (Statusbar shows "Connecting to the web"), and left the rest undone unless I press Ctrl+Alt+Del to end the process and run the macro again.
MY QUESTION:
Is there any solution to add a time limit to a web query so that if the query takes up too much time it abandons the current query and continue with the rest?
Thanks in advanced to anyone who could offer valuable suggestions!
And the problem is that once in a while it just paused at one of the query for a long time (Statusbar shows "Connecting to the web"), and left the rest undone unless I press Ctrl+Alt+Del to end the process and run the macro again.
MY QUESTION:
Is there any solution to add a time limit to a web query so that if the query takes up too much time it abandons the current query and continue with the rest?
Thanks in advanced to anyone who could offer valuable suggestions!
