MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Perform same task every day at same time automatically?

  Asked By: Carolina    Date: Feb 23    Category: MS Office    Views: 1723

I want to write a macro to open a webpage at 11:10 am every day.

I can do this one day at a time using the OnTime function (assuming
that I remember to set it--but sometimes I forget).

Seems like there must be a way to loop this so it repeats
automatically, but the method is elusive.

Can anybody help? Thank you.



1 Answer Found

Answer #1    Answered By: Adalie Fischer     Answered On: Feb 23

I would use the built-in Windows functionality called Scheduled Tasks. You
can probably add a scheduled task  to the system programmatically using the
Win32 API (though I haven’t looked at the docs), or since you can also add
tasks on the command line using C:\WINDOWS\SYSTEM32\SCHTASKS.EXE (use /? At
the command line for more help, and specifically SCHTASKS /CREATE /? for
help on creating a scheduled task), you can add a task programmatically
using the VBA Shell command to run the desired command line. You can also
use the GUI at Start/Programs/Accessories/System Tools/Scheduled Tasks, or
in the Control Panel.

Didn't find what you were looking for? Find more on Perform same task every day at same time automatically? Or get search suggestion and latest updates.