$oExcel.ActiveWorkbook.Save() started Failing

[Wolfiesaxah]

I have a script that opens an excel file then checks each rows, deleting bad ones etch. After the process the script does a "$oExcel.ActiveWorkbook.Save()" to save the changes made (the file is .xlsx). This part of the script has always worked in the past but recently started giving me an error 

 ==> The requested action with this object has failed.:
$oExcel.ActiveWorkbook.Save()
$oExcel.ActiveWorkbook.Save()^ ERROR

Then after getting this error I try to check the Excel file but it is not clickable, the save button is not clickable either, only the X or Close Window button is. Could I be getting this error because Excel somehow froze? Can anyone tell me why it was freezing at that point? It has worked well in the past.

[JLogan3o13]

Wolfiesaxah, do you honestly think we will be able to troubleshoot your issue based on a single line of code? How about posting the entire code, or at least a runnable reproducer.

And while we're at it, is there a reason (have to ask, since your code isn't posted), you're not working with the built in Excel functions to save and close the workbook?

[dmob]

I think I might have had a similar problem in the past, check if it's not related to this...

from the help file for _ExcelBookSaveAs:

Starting with Excel 2007 you have to provide both the $iFormat parameter and the correct file extension in $sFilePath.
E.g. $iFormat = $xlExcel8 and extension = "xlsx" will return an error.
 

 

Just a long shot, but I suspect your problem might be related to dissimilar formats when opening and saving your workbook.

 

[Wolfiesaxah]

Thanks guys, I'm not sure what the problem is but I tried debugging and all I can see is that the Excel save button is disabled so that could be why the script is failing at saving so I modified my script to just open the excel file to get the required data then closing Excel without saving. I am using notepad and string concatenation as planB since using Excel seem to be more complicated.

[water]

Please post your script so we can have a look at it.
Automating Excel using the builtin UDF is not complicted at all.