Thread: QUERY halts VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default QUERY halts VBA

What does the continue box say?

Usually if your are perfroming a query more than once you are overwriting
the previous data and the message box verifies that you want to overwrite the
previous query data. Onme solution is to write each query to its own
worksheet.

"sharon" wrote:

Hi,

I have a macro with 4 querys to URL files.
When I debug the macro manually it works OK, but when executing the macro,
VBA halts and wait for USER input. If I select to "Continue" everything goes
fine.

How can I avoid this step?

TIA,
Sharon