Wait function in Excel 2000 Macro

F

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
 
D

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???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

variable in a chart macro 1
Excel can't find macro 2
Application wait question 4
Macro Compatability 1
Running SPSS-Syntax using Excel VBA (Excel 2013) 0
Excel 2007: Help creating a macro that will run Solver? 3
Auto increment & print three copies 5
Macro Help 3

Top