Task Scheduler and COM automation

Note to self:

The solution for this appalling BUG in Microsoft IIS & Excel is terrific:

  1. Create directory "C:\Windows\SysWOW64\config\systemprofile*Desktop* " (for 64 bit Windows) or "C:\Windows\System32\config\systemprofile*Desktop* " (for 32 bit Windows)
  2. Set Full control permissions for directory Desktop (for example in Win7 & IIS 7 & DefaultAppPool set permissions for user
    "IIS AppPool\DefaultAppPool")

http://social.msdn.microsoft.com/Forums/en/vbgeneral/thread/4d6c383a-94eb-4898-9d22-aa4bb69be25b