How to set recurring schedule for xlsm file using Windows Task Scheduler

by

Better to use a vbs as you indicated

  1. Create a simple vbs, which is a text file with a .vbs extension (see sample code below)
  2. Use the Task Scheduler to run the vbs
  3. Use the vbs to open the workbook at the scheduled time and then either:
    • use the Private Sub Workbook_Open() event in the ThisWorkbook module to run code when the file is opened
    • more robustly (as macros may be disabled on open), use Application.Run in the vbs to run the macro

See this example of the later approach at Running Excel on Windows Task Scheduler

sample vbs 

Dim ObjExcel, ObjWB
Set ObjExcel = CreateObject("excel.application")
'vbs opens a file specified by the path below
Set ObjWB = ObjExcel.Workbooks.Open("C:\temp\rod.xlsm")
'either use the Workbook Open event (if macros are enabled), or Application.Run

ObjWB.Close False
ObjExcel.Quit
Set ObjExcel = Nothing

More Related Contents:

  1. Run Excel Macro from Outside Excel Using VBScript From Command Line
  2. Export each sheet to a separate csv file
  3. Code for looping through all excel files in a specified folder, and pulling data from specific cells
  4. Bad data selection using VBScript , on date field values
  5. SumIf using Excel VBA
  6. How can I call a macro which contains a loop but only run one iteration of that loop?
  7. VBA comma separated cells, needt last entry only
  8. How can I find last row that contains data in a specific column?
  9. Copy from one workbook and paste into another
  10. Open Excel file for reading with VBA without display
  11. Wait for shell command to complete [duplicate]
  12. Difference between ‘on error goto 0’ and ‘on error goto -1’ — VBA
  13. What are .NumberFormat Options In Excel VBA?
  14. Excel: How to check if a cell is empty with VBA? [duplicate]
  15. ShowAllData method of Worksheet class failed
  16. Assign keyboard shortcut to run procedure
  17. Excel macro -Split comma separated entries to new rows [duplicate]
  18. Get text from clipboard using GetText – avoid error on empty clipboard
  19. Benchmarking VBA Code
  20. Display milliseconds in Excel
  21. VBA editor auto-deletes spaces at the ends of lines
  22. Select entire column in table using Excel VBA
  23. Application.Quit command not closing the entire Excel Application
  24. Trying to open the workbook in separate instance
  25. Excel VBA – select multiple columns not in sequential order
  26. How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
  27. Application.WorksheetFunction.Match method
  28. Excel – Using COUNTIF/COUNTIFS across multiple sheets/same column
  29. Call a Unix Script from Excel Vba
  30. Excel telling me my blank cells aren’t blank

Leave a Comment