Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Outllok 2000 macro: how to repeat it every....

Status
Not open for further replies.

chiuso2

MIS
Feb 22, 2002
58
Hi there.
I made a macro and i would like run it every 2 minutes...
everyone could tell me how to do that???

Thanks in advance

Mario from Italy
 
I'm not really knowledgeable in VBA, but I'm interested. I found an example on the internet using Application.Wait Now + TimeValue("00:02:00") and I figure you would need to use a Do...Loop or Do...Loop Until. Would you need to specify a condition to be met to stop the macro at some point?

Do
[insert your existing macro language here]
Application.Wait Now + TimeValue("00:02:00")
Loop

or

Do
[insert your existing macro language here]
Application.Wait Now + TimeValue("00:02:00")
Loop Until
[insert rest of macro here for condition]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top