How can i add a 500 ms delay

[mtheriault2000]

Hello

I'm doing a screen capture with Hypersnap, but Excel is to fast. How can i add a 500ms delay before looking for the new created file. Screen is captured then a new file is created. Problem, i always get the previous file because Excel is faster than the captured software.

Or, should i loop in the directory until the file exist?

Martin

 

[VoG]

Try this - it will give a 1 second delay

Application.Wait Now + TimeSerial(0, 0, 1)

 

[Richard Schollar]

Hi Martin

If you want a 500ms delay then you can use the Sleep API function:

'at the top of a standard module:

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

'in your sub:

'...whatever previous code...

Sleep 500   'ie 500 milliseconds

'continue with sub...

 

[mtheriault2000]

Thank you VOG / Richard

Vog, 1 sec is too long. Richard solution is what i was looking for.


Have a great day

Martin

 

[Cerebum]

Added thanks. I just used this to great effect Thanks