Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I build a pause (or delay) into my macro?
I am running a macro that activates a 2nd macro, waits for the data to
load (maybe 5-10 seconds) then outputs the response, then an identical macro #3 etc. through #10. Each rnning from a different data set. The problem I am having is that my meta-macro (that runs #1 through #10) runs so fast I cannot look at the output between each one. I want my meta-macro to run #1, pause 15 seconds so I can manually look at the data and then run #2, but I have no clue how to write a pause command in the code (yes, I am a total newbie!) Thanks for any pointers! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I build a pause (or delay) into my macro?
Try this line of code to make the macro wait
Application.Wait Now + TimeValue("00:00:15") -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address to reply by email ** "R" wrote in message ... I am running a macro that activates a 2nd macro, waits for the data to load (maybe 5-10 seconds) then outputs the response, then an identical macro #3 etc. through #10. Each rnning from a different data set. The problem I am having is that my meta-macro (that runs #1 through #10) runs so fast I cannot look at the output between each one. I want my meta-macro to run #1, pause 15 seconds so I can manually look at the data and then run #2, but I have no clue how to write a pause command in the code (yes, I am a total newbie!) Thanks for any pointers! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I build a pause (or delay) into my macro?
Look in help at the Wait command.
-- Regards, Tom Ogilvy "R" wrote in message ... I am running a macro that activates a 2nd macro, waits for the data to load (maybe 5-10 seconds) then outputs the response, then an identical macro #3 etc. through #10. Each rnning from a different data set. The problem I am having is that my meta-macro (that runs #1 through #10) runs so fast I cannot look at the output between each one. I want my meta-macro to run #1, pause 15 seconds so I can manually look at the data and then run #2, but I have no clue how to write a pause command in the code (yes, I am a total newbie!) Thanks for any pointers! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pause a macro | Excel Discussion (Misc queries) | |||
How do I pause a macro? | Excel Discussion (Misc queries) | |||
How to build build a macro that automatically imports | Excel Programming | |||
Can you build in a delay... | Excel Programming | |||
Pause macro | Excel Programming |