Task Scheduler and COM automation
Note to self:
The solution for this appalling BUG in Microsoft IIS & Excel is terrific:
- Create directory "C:\Windows\SysWOW64\config\systemprofile*Desktop* " (for 64 bit Windows) or "C:\Windows\System32\config\systemprofile*Desktop* " (for 32 bit Windows)
- 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