Application.Wait

[EByker]

VBA for Excel contains the command Application.Wait ("time").

It does not however work in a Word application. Is there a similar command for VBA in Word?

Thanks.

Bertie

[ansumansahu]

VBA for Excel contains the command Application.Wait ("time").

It does not however work in a Word application. Is there a similar command for VBA in Word?

Thanks.

Bertie

Put this
into your Declarations section in either your module
or form/report source code:

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

Here's a sample call:

Sleep (5000) ' Waits for 5 seconds


-ansuman sahu

[EByker]

Put this
into your Declarations section in either your module
or form/report source code:

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

Here's a sample call:

Sleep (5000) ' Waits for 5 seconds


-ansuman sahu

Thanks!

Does this procedure "sleep" the application only, or the system?

B

[Denburt]

Only the program it is used in:

The Kernel32 contains a function that pauses a program's execution for a specified amount of time, specified in milliseconds. For you to use the function, it must first be declared in the General Declarations section of the module in which it will be used:

More info and other methods you can use

:) I hope that answers your questions.

[EByker]

Only the program it is used in:



More info and other methods you can use

:) I hope that answers your questions.

Yes, it certainly does. Thanks a lot!

B