Getting a Run Time Error 13 - Type mismatch on the application.quit

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!
 
Top