PowerShell Script running Excel won't run on Windows Server 2008 R2

i have script creates report of single example of each warning or error in windows event log, each server in list of servers,with number of times error has occurred in last week on each server. creates report in excel. have script running automated through task scheduler 1 client on windows 7 , it's working perfectly. have client attempting run script automated on server running windows server 2008 r2. can manually run script , works, if try schedule script works except excel powershell commands. i've have tried:

created desktop folders config\systemprofile in system32 , in syswow64.

configured permissions in dcom microsoft excel application.

configured folder permissions config\systemprofile.

verified powershell working.

unchecked option in task run while logged on.

does have idea why happening , how can fix it? thanks!

sincerely,

christopher beard

you might have launch application once system account can set excel environment, i've had same problem when  trying update excel files admin powershell console using admin account.  use psexec -s option run system account locally while logged on target server:

psexec -s "c:\program files (x86)\microsoft office\office14\excel.exe"

then you'll prompted input initials - suspect preventing code running properly.

there may other more elegant way handle this, you'd better off asking question in 1 of forums devoted office products.

---

i hope post has helped!

Windows Server  >  Windows PowerShell