Windows task scheduler to automatically open(then close) an excel workbook

I want to run a routine at a specific time daily. I tried windows task scheduler by selecting the file in the folder but at the scheduled time a popup asked me "how do you want to open this file" which defeats the purpose of the automation. Does anyone know how to suppress this alert or any other way to accomplish what I want to do? Any help appreciated!

As you fill out the task when it comes to the part for action, select "Run a Program" then fill in:

"Full Path to Excel Executable" 'Full Path to Spreadsheet to open"

For example on my machine the executable is in C:\Program Files (x86)\Microsoft Office\root\Office16 so I enter:

"C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\dflak\Scripts\DPR Thursday.xlsm"

When entered as the whole line, the Task Scheduler will detect that you are passing an argument to Excel and ask if you want to separate it. Answer Yes.

This program opens the file DPR Thursday.xlsm.

The task scheduler can open a file, but it can't run a macro. So I arrange it so the task scheduler opens the script (which has code to run automatically on open) and the script runs a macro in the target spreadsheet. I have two directories: one to hold the scripts and a parallel directory to hold the target workbooks.

http://www.utteraccess.com/wiki/Schedule_a_Macro_to_Run

Copy the action line in the script into the action line in the task scheduler.

Thank you@dflak.

I tried vbscript and it works in the folder (double click the file) but the popup still shows when I tried to run it in the scheduler. I also tried the combination of batch file (combined with vbscript). It also works in the folder but it doesn't work either in the scheduler, although the popup didn't show, instead I noticed flashing (looks like working but nothing happens).

And I think it worked when I first tried somehow it stopped working after two days. Don't know why.

1. Vbscript (file name mymacro.vbs) - when in the folder it works. But in scheduler the popup shows up.

Please Login or Register  to view this content.

2. Batch (combined with vbscript):
vbscript (file name script.vbs)

Please Login or Register  to view this content.

And batch (file name: runit.bat) - when click runit.bat in the folder it works. In scheduler it only flashes but the macros are not run.

Please Login or Register  to view this content.