| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wait function in Excel 2000 Macro
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wait function in Excel 2000 Macro
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wait function in Excel 2000 Macro
And when you tested it in a small macro, what happened?
fryb53 wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When Excel wait for OLE action allow cancel so not have to end pr | Excel Discussion (Misc queries) | |||
| Does Excel 2000 have an undo function after using a macro? | Excel Worksheet Functions | |||
| Wait while Windows Configures Microsoft Office 2000 | Excel Discussion (Misc queries) | |||
| Macro in Excel 2000 | Excel Discussion (Misc queries) | |||
| How do I get an excel macro to stop at a cell & wait for imput? | Excel Discussion (Misc queries) | |||
Linear Mode
