I am facing a curious problem.
When I ran this code :
$Excel = New-Object -Com Excel.Application
$book = $Excel.Workbooks.Add()
[threading.thread]::CurrentThread.CurrentCulture = 'en-US'
Stop-Process -Name "Excel*"
in PowerGui, POwerSHell host..anywhere, it works beatiful.
If I put into a .bat and calls powerhsell “c:\temp\excel.ps1” works fine too.
But If i try to schedule this guy into schedule task or run by a sql server job type cmd the error happens :
Exception calling “SaveAs” with “1” argument(s): “SaveAs method of Workbook cla
Only when It is called by SQL Server Jobs ( that is a simple cmd command too and the line is the same as the .bat powerhsell “c:\temp\excel.ps1” ) the error happens.
What it can be ? I tried change the fileformat..etc..and nothing
Thanks Guys 🙂
The Solution is :
You have to create a folder (or two on a 64bit-windows):
The solution is in the Forum :