| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pausing in Excel VBA
Is there a better way of pausing Excel than: Application.Wait waitTime I have code that I would like to run either every 30 minutes or every 60 minutes, but I really hate the way the Appliaction.Wait function works. (The way it just locks up the application.) Thanks! Joey |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pausing in Excel VBA
application.ontime
Tim "Joey Lichtenstein" wrote in message ... Is there a better way of pausing Excel than: Application.Wait waitTime I have code that I would like to run either every 30 minutes or every 60 minutes, but I really hate the way the Appliaction.Wait function works. (The way it just locks up the application.) Thanks! Joey |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pausing in Excel VBA
See the examples at
http://www.cpearson.com/excel/ontime.htm -- Regards, Tom Ogilvy "Tim Williams" wrote: application.ontime Tim "Joey Lichtenstein" wrote in message ... Is there a better way of pausing Excel than: Application.Wait waitTime I have code that I would like to run either every 30 minutes or every 60 minutes, but I really hate the way the Appliaction.Wait function works. (The way it just locks up the application.) Thanks! Joey |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel pausing | Excel Discussion (Misc queries) | |||
| Open an Excel Workbook from either a BAT (or VBS) without pausing. | Excel Programming | |||
| Pausing macro for user Excel input | Excel Programming | |||
| Pausing macro for user Excel input | Excel Programming | |||
| Pausing macro for user Excel input | Excel Programming | |||
![Joey Lichtenstein[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
