Task scheduler + VB script to auto open protected excel workbook

[redginseng]

Hi everyone,

I am trying to use VBscript and Cscript to put in windows task scheduler to auto run a sub at a certain time every business day.

So for my windows batch file, I have

------------
Cscript UMSscript.vbs "\\SHAREDrive\path\Controlfile.xlsm"
------------

and in my VBscript file, I have

------------
dim args, objExcel


set args = wscript.arguments
set objexcel = createobject("Excel.Application")


objexcel.workbooks.open(Filename:="\\SHAREDrive\path\Controlfile.xlsm", Password = "pass_word")
objexcel.visible = true


objexcel.run "autorunums"


objexcel.activeworkbook.save
objexcel.activeworkbook.close(0)
objexcel.quit
----------

Can't get this to work. I appreciate any help.
Thank you in advance!