Launch VB Script Using Task Scheduler

How to launch a VB script using the task scheduler at a specific date and time automatically. Watch the video below:

Watch this video on YouTube.

Next to the Windows icon in the text box ‘Type here to search’, start typing ‘task…’ and you’ll be able to view the Desktop App ‘Task Scheduler’. Select to open the ‘Task Scheduler’ window.

In the Task Scheduler Window you can read the ‘Overview of Task Scheduler which guides us on how to use the App.

Click on ‘Action’ in the menu bar and select ‘Create task…’ In the ‘Create Task’ window that pops up, enter a name for the task like ‘Import Data from Word Table’ .  In the ‘Description’ area write a description of  the task like ‘Data is imported from a Word table into an Excel worksheet’.

In the security options you can select when you wish to run the task and with what privileges.

Under ‘Configure for’ we can select our Operating System like Windows 10 or just leave the entry as it is and finally click on ‘OK’.

Next we click on the ‘Actions’ tab and in the settings under ‘program/script’ we can browse to our script and select it and therefore insert the path automatically in the text-box and then click OK. We can also define some other parameters like ‘Add arguments’ and ‘Start in’ if we wish to do so. Finally click OK.

Next we click on the ‘Triggers’ tab, select ‘New…’ and the ‘New Trigger’ window opens. Here we can select under ‘Begin the task’ an appropriate condition. Under ‘Settings’ we have the option to trigger the action one time, daily, weekly or monthly.

Under the ‘Advanced Settings’ we can select more actions according to our requirements and finally check the ‘Enabled’ box and click OK.

In the conditions tab we can specify the conditions that along with the trigger will determine whether the task will run or not.

In the settings tab we can select additional settings that will effect the behavior of the task.

If we have specified a date and time for the task, the task will execute accordingly and thus our automation will be complete i. e. our task scheduler fires the VB Script which in turn executes our macro.

Further Reading:

Run Macro Automatically without Opening Excel File

Published by

Dinesh Kumar Takyar

Welcome to exceltrainingvideos.com! My aim is to help you learn MS Excel including VBA. I always felt that a good way to learn something was to find solutions to problems in that domain. That is why I share these Excel videos with you. Mostly these are questions asked during my corporate training sessions. I've been training individuals and companies in computers since 1991. I did my B. Sc. (Vordiplom), M. Sc. (Diplom) and Ph.D. (Dr. rer. nat.) from Hamburg, Germany. The best thing about solving some of my visitor's questions is that I also gain new insights. For more Excel VBA solutions you may like to visit my YouTube channel: http://youtube.com/familycomputerclub For a structured Excel VBA training course online you can visit: https://www.youtube.com/excelvbaonline

One thought on “Launch VB Script Using Task Scheduler”

  1. Hi have excel file which sends email. I have created vbs script and bat file to run this automatically through task scheduler. It perfectly runs manually however it fails in task scheduler.
    Will you please help me?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.