Wait function in Excel 2000 Macro

[fryb53]

I have used the following code in a Macro (97 & 2000) on XP:
Application.Wait Time + TimeSerial(0, 0, MyDelay)
Where my delay is time in seconds. This function will not run in the Vista
operating system? Any ideas?
Thanks,
A

 

[Dave Peterson]

You message is the first I've seen that describes this problem.

What is your value of myDelay?

Maybe you can test it in a small macro with a delay of 10 seconds???

 

[fryb53]

I use a myDelay value of 5 which seems to be 5 seconds.

A

 

[Dave Peterson]

And when you tested it in a small macro, what happened?