vbs doesn't work when scheduled

[d0gb3rt]

This script will work when run manually but not when run by the Windows 7 64 bit task scheduler. It will run fine with the Windows 2003 Server task scheduler.

Save the following as test.vbs
---------------------------------------------------------


begin

Sub begin

Set excel = CreateObject("Excel.Application")
excel.DisplayAlerts=false

Set wb = excel.workbooks.open("C:\test.xlsx")
wb.sheets(1).cells(1,1).value="hello"
wb.save
wb.Close
excel.Quit

End Sub

 

[SkipVought]

hi,

Please post VBS in forum329.

There is often a fundamental problem opening an Excel workbook automatically, that has macros that need to run. WHO PRESSES THE OK?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[d0gb3rt]

ok. I will post it in the other forum. Actually, there are no VBA macros in the excel workbook.