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

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

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