This article is not related to Excel Macro. This is useful when you want to do some Job by excel Macro automatically. For example, if you want to send an Email Every Day automatically, without any manual intervention, then this task scheduling will come into the picture. If you want to know how to Send an Email Automatically from your system on a specific day and time.. then read my Next Article.

How to schedule a task in Windows

A step-by-step guide to scheduling a task in Windows.

• Go to the Control Panel of your System
• Click on System and Security
  

  1. Control panel System and security

• Click on Schedule Task in Administrative Tools.
  

  2. Schedule task in Admin tool

• Click on Create Task…
  
  

  3. Create a new Task

• Enter the Name and Description of the Task you want to Schedule
• Select the Security options Appropriately
• Click Ok
  

  4. Create task – Window

• Go to Triggers Tab
• Click on New
  

  5 Create a Trigger

• Set the appropriate Schedule as per your requirement.
• For Example: here I have scheduled for Daily 9:00 AM from 30th June.
  You can also do some advanced settings in the Advanced Settings Section below.
  Check the Enabled Check Box to make the Task Enabled and Click OK
  

  6 – New Trigger schedule

• Schedule is Added here as shown below
  
  

  7-Schedule is added

• Go to Action Tab
• Click on New
  

  8 – Add Action

• Select “Start a Program” from Action Drop Down
• Browse your File or Script file from your Local System.
  For Example, I have selected one VB Script File.
• Click OK
  

  9 – Action File added

• One Action is Added
• Click OK
  

  Action File added

• Go to Condition Tab
• You can select any of the options as per your requirement.
  

  Task Condition

• Go to Settings Tab
• Select the appropriate Option as per your requirement.
• Click OK
  

  Task Settings

• And you are done. Your Task is Scheduled
  
  

  Task schedule added

You can download the steps in a presentation