FactoryTalk SE-VBA time delay

I am using some VBA to move a few backup files around. I have found that I need to have a time delay in place to wait for some of these steps to take place. I back up an SQL database then move it to a thumbdrive, I need to wait for the database to backup before I can move it. I keep coming up short in my attempts to make a time delay work. I did this "application.Wait Now + TimeValue("0:00:30")" but does not work. I am not sure if its because I do not have a Reference made in VBA (under tools-Reference). Can anyone point me in the right direction?
THanks!!!!
Stoop

Ohh its FE Studio 6.0 VBA version 6.5

try this code

Dim PauseTime, Start, Finish, TotalTime
PauseTime = 1
Start = Timer
Do While Timer < Start + PauseTime
DoEvents
Loop
Finish = Timer


'put your copy code here'

DoEvents allows the other processes to run
pause time is in seconds

I have used it for delaying events in FT5 and it works and allows other processes to run in the background. I think application.Wait halts all VBA operations

kyle

Kyle...Thanks this is perfect!!!! Thanks so much!!

No problem I rarely get the chance to give out helpful advice on this forum.