Help with Task scheduler to run a Macro

[Lycn]

Hi! I need help filling out the form for task scheduler.

Goal: have a macro run everyday at the same time - file name c:\Script.xlsm
My macro runs perfectly.

I have a run.bat file
and a Script.vbs file.

It runs the macro if I click on the run.bat file.

run.bat code: cscript script.vbs "C:\script.xlsm"

Script.vbs code:
Dim args, objExcel

Set args = WScript.Arguments
Set objExcel = CreateObject("Excel.Application")

objExcel.Workbooks.Open args(0)
objExcel.Visible = True

objExcel.Run "test"

objExcel.ActiveWorkbook.Save
objExcel.ActiveWorkbook.Close(0)
objExcel.Quit

So all the parts seem to be working, but I can't get the task scheduler to work. It opens the excel file but doesn't run the macro.

could someone please tell me how to fill out this form?
picture attached. taskscheduler.jpg

Thanks!

[buran]

In your workflow it should be just the bat file.
However, going up one leve you can also just start cscript with 2 optional arguments - script name and the excel file
Now, actually the simplest solution would be to use Workbook_Open event to start your macro. In this case you will need just to start (i.e. open) the excel file with the macro. no need to use the vbs script or bat file. Note that you may need to change your macro a bit as I see that vbs scropt saves and close the xlsm file. You will need to add this to your macro

[buran]

OK, I test it and it actually fails to run macro if you run the bat file.
So I tried to run the vbs file with path to the excel file as optional argument and it works fine. see attached image

Screenshot 2015-08-07 09.21.40.png

Anyway I think best solution is to skip also the vbs file.

[Lycn]

THANK YOU!!! works perfectly