SHIFT

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

User Tools

Site Tools


Sidebar

Recently Changed Pages:

View All Pages


View All Tags


LinkedIn




WIKI Disclaimer: As with most other things on the Internet, the content on this wiki is not supported. It was contributed by me and is published “as is”. It has worked for me, and might work for you.
Also note that any view or statement expressed anywhere on this site are strictly mine and not the opinions or views of my employer.


Pages with comments

View All Comments

fixexcelpowershell

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 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:

You'll always have to create this folder:

C:\Windows\System32\config\systemprofile\Dektop

And if you're running 64bits you also have to create this folder:

C:\Windows\SysWOW64\config\systemprofile\Desktop

Now it will work.

You could leave a comment if you were logged in.
fixexcelpowershell.txt · Last modified: 2021/09/24 00:24 (external edit)