delay macro

  • Thread starter Thread starter dddd
  • Start date Start date
D

dddd

Hi
I want to do macro that do one command, stop for a while, and then do the
next one.
Example:
I want to do "runcommand, filterbyform", then to stop until the form event
"apply filter", then to open another form, and when it close, to open a
report. I know I can split the macro to 3 macros that will be activate each
in his event, but then, evrytime I'll close the form the report will be
open,
what I dont want to happen.
Do you have an idea?
Thank's
Daniel
 
Good morning Daniel

You could make the application 'sleep' for a while between the various steps.
The following will do that for you.


Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

'Call the function as follows
Sleep 4000 ' delay for 4 seconds


Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
Back
Top