Auto-run macro every x minutes

ossobucco · Apr 30th, 2002, 02:15 AM

Is there a way to program a macro to run automatically at constant time intervals? Every 15 minutes or so?

Thanks a lot in advance!
ob

Ivan F Moala · Apr 30th, 2002, 03:14 AM

Quote:

On 2002-04-30 01:15, ossobucco wrote:
Is there a way to program a macro to run automatically at constant time intervals? Every 15 minutes or so?

Thanks a lot in advance!
ob

look up the Ontime method in the VBA Editor
Post if you require further help.

Audiojoe · Apr 30th, 2002, 03:22 AM

I had to do this the other day. Say your macro is called "Allhailthereturnoftheking" then put this right at the end of your macro, just above End Sub

Application.Ontime Now + TimeValue("00:15:00"), "Allhailthereturnoftheking"

Audiojoe
This is how you remind me

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 02:15 AM	#1
ossobucco New Member Join Date: Apr 2002 Posts: 1	Is there a way to program a macro to run automatically at constant time intervals? Every 15 minutes or so? Thanks a lot in advance! ob

Apr 30th, 2002, 03:22 AM	#3
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	I had to do this the other day. Say your macro is called "Allhailthereturnoftheking" then put this right at the end of your macro, just above End Sub Application.Ontime Now + TimeValue("00:15:00"), "Allhailthereturnoftheking" Audiojoe This is how you remind me