Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

how do you pause excel query

Posted on 2011-09-07
2
Medium Priority
?
199 Views
Last Modified: 2012-05-12
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
Comment
Question by:u002dag
2 Comments
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 750 total points
ID: 36499201
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
 

Author Closing Comment

by:u002dag
ID: 36504475
thanks
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question