Can't schedule Program with Excel Interop
Check this out. Looks like you have to create a folder to get this thing to work right.
C:\Windows\System32\config\systemprofile\Desktop
Taken from this article here
http://social.msdn.microsoft.com/Forums/en/innovateonoffice/thread/b81a3c4e-62db-488b-af06-44421818ef91
In short make sure to create these folders with appropriate rights for the profile used in the task scheduler and that is is not readonly:
C:\Windows\System32\config\systemprofile\Desktop C:\Windows\SysWOW64\config\systemprofile\Desktop
And check this:
From the Start menu, click Run and type Dcomcnfg.exe. In Component Services, click Console root, expand Component Services, expand Computers, expand My computer,expand DCOMConfig. Search for Microsoft Word 14.0 Object Library. Click on it. Right click and select Properties. On security tab, select Customize in "Launch and Activation" section. Click edit and add identity of app pool under which you application is running. Repeat above step for "Access Permission"