Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
QUERY halts VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
QUERY halts VBA
Hi Joel,
Message box says "Code execution has been interrupted " Then you have Continue, Debug or Help buttons As said, when Continuing program runs until next halt (QUERY) and so on. It seems to me it has relation with time between steps in the code, but I never saw this before. Something to do with QUERY settings perhaps? 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
QUERY halts VBA
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"ClearContents" command halts code | Excel Discussion (Misc queries) | |||
This Macro halts any ideas what could be wrong | Excel Worksheet Functions | |||
Computer halts while opening an excel file?? | Setting up and Configuration of Excel | |||
Sub halts with Run-time error '-2147024809 (80070057) specified value is out of range | Excel Programming | |||
VBA code halts after opening a file | Excel Programming |