SHIFT

--- Sjoerd Hooft's InFormation Technology ---

User Tools

Site Tools


fixexcelpowershell
Differences

This shows you the differences between two versions of the page.

Link to this comparison view

fixexcelpowershell [2013/05/02 10:07]
sjoerd created
fixexcelpowershell [2013/05/02 10:07] (current)
sjoerd
Line 1: Line 1:
-= Fix: Editing Excel Documents With Powershell as Scheduled Job Failes ​=+= Fix: Editing Excel Documents With Powershell as Scheduled Job Fails =
  
 Due to some weird issues with excel or powershell (nobody knows for sure although Microsoft claims it's not supported [[http://​support.microsoft.com/​kb/​257757|here]] ) it seems impossible to edit, create or save Excel documents with powershell when running it as a scheduled job, when set that the user running the task does not have to be logged on. Searching the Internet there is a solution, which worked for me and a lot of other people. You'll have to create some folders depending on if you're running Windows in 32bits or 64bits: Due to some weird issues with excel or powershell (nobody knows for sure although Microsoft claims it's not supported [[http://​support.microsoft.com/​kb/​257757|here]] ) it seems impossible to edit, create or save Excel documents with powershell when running it as a scheduled job, when set that the user running the task does not have to be logged on. Searching the Internet there is a solution, which worked for me and a lot of other people. You'll have to create some folders depending on if you're running Windows in 32bits or 64bits:
fixexcelpowershell.txt ยท Last modified: 2013/05/02 10:07 by sjoerd