Hi,

Internet is really helpful !

I found somebody had exactly the same troubles. Solution came after
inserting at the beginning of the code:

Application.EnableCancelKey = xlDisabled

All run fine now!

HTH,
Sharon

"Joel" wrote:

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