Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 209
  • Last Modified:

how do you pause excel query

Hi,
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.
0
u002dag
Asked:
u002dag
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.

Kevin
0
 
u002dagAuthor Commented:
thanks
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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