interval in access macro

[new2ora]

I have a macro in Access 2002 that has 2 steps. Step1 launches an external application which creates a text file. Step2 opens that file for viewing. I want the second step to run after 60seconds of the first one being launched! Otherwise the maro opens the old file!!

Any Ideas???

 

[LittleSmudge]

Forget macros and do it in VB code

Dim datOpeningTime as Date
datOpeningTime = Now() + ( 1/(24*60))
Launch App
While datOpeningTime > Now()
DoEvents
Wend
Open File




'ope-that-'elps.




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.