Does anyone know how to introduce a time delay into VBA macros? I created a
macro that runs an application on about 15 different worksheets. I want to
be able to have the macro pause between worksheets, to allow this application
to have enough time to download on every sheet. Is this possible? If so,
what code would I need?

Thanks

Adam Bush

You might try application.wait:-

Application.Wait Now + TimeValue("00:00:10")

will cause a 10 second pause.

Mike

" wrote:

Does anyone know how to introduce a time delay into VBA macros? I created a
macro that runs an application on about 15 different worksheets. I want to
be able to have the macro pause between worksheets, to allow this application
to have enough time to download on every sheet. Is this possible? If so,
what code would I need?

Thanks

Adam Bush

http://groups.google.com/group/micro...6233c7f24fcd23

Hth,
Merjet

Thanks for your help Mike. It worked perfectly. I was wondering if you
could do partial seconds.

Thanks

Adam Bush

"Mike H" wrote:

You might try application.wait:-

Application.Wait Now + TimeValue("00:00:10")

will cause a 10 second pause.

Mike

" wrote:

Does anyone know how to introduce a time delay into VBA macros? I created a
macro that runs an application on about 15 different worksheets. I want to
be able to have the macro pause between worksheets, to allow this application
to have enough time to download on every sheet. Is this possible? If so,
what code would I need?

Thanks

Adam Bush