View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
fryb53 fryb53 is offline
external usenet poster
 
Posts: 3
Default Wait function in Excel 2000 Macro

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

A

"Dave Peterson" wrote:

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 wrote:

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