D
dancing
Hi,
I am trying to automate one of my excel process using windows AT
scheduler. I know AT rus under a special system acount. however, it
always gives me a run time error 13 when i do the application.quit
call.
Here is my function:
********************************************************
sub auto_open
debug.print "Hello World"
application.quit
end sub
********************************************************
Here is how I bring up the excel through AT command line:
********************************************************
AT 18:33 /EVERY:W C:\startExcel.bat
********************************************************
Here is my startExcel.bat
********************************************************
set EXCEL_DIR=C:\Program Files\Microsoft Office\Office10\Excel.exe\
set PATH=%EXCEL_DIR%;$path
excel.exe testing.xls
********************************************************
Please Help!
I am trying to automate one of my excel process using windows AT
scheduler. I know AT rus under a special system acount. however, it
always gives me a run time error 13 when i do the application.quit
call.
Here is my function:
********************************************************
sub auto_open
debug.print "Hello World"
application.quit
end sub
********************************************************
Here is how I bring up the excel through AT command line:
********************************************************
AT 18:33 /EVERY:W C:\startExcel.bat
********************************************************
Here is my startExcel.bat
********************************************************
set EXCEL_DIR=C:\Program Files\Microsoft Office\Office10\Excel.exe\
set PATH=%EXCEL_DIR%;$path
excel.exe testing.xls
********************************************************
Please Help!