This shouldn't be a difficult question but I am trying to automate an autosaving excel 2007 workbook. This workbook is open 24/7 btw. I am going to create a vb script that does this and just put it in the Task Scheduler but I am having an issue with the script. The code below is what I have so far (it works) but I don't want to 'open' the workbook everytime. I just want to activate it. Thanks in advance!
Set args = WScript.Arguments
Set objExcel = CreateObject("Excel.Application")
objExcel.DisplayAlerts = False
Set objWorkbook = objExcel.Workbooks.Open("C:\test.xls")
objExcel.AlertBeforeOverwriting = False