• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • Last Modified:

how do you pause excel query

I have a simple web query that brings in data every second and writes to an Excel Worksheet. How do I pause it? So that I can look at the data for few minutes and then start it back up.
1 Solution
zorvek (Kevin Jones)ConsultantCommented:
What I would do is add a command button to the worksheet that runs a macro which sets a global switch. Monitor the switch in the code that does the query and only do the query if the switch is set one way. You will need a DoEvents in the query loop to allow Excel to process the button clicks.

u002dagAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now