Unable to overwrite excel file

[Champak]

Is there a way to test in autoit if an excel file is currently read only?...or simply tell me why this isn't working?

My app opens an excel file and reads it to an array, I then call excel_close.

Later in another function I try to save to that file I originally open and I use different variables if it matters like:

_Excel_Close($oExcel)

                ; Create application object
                Local $oExcel2 = _Excel_Open()
                If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookOpen Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

                ; Create a new workbook with only 2 worksheets
                ;$oWorkbook = _Excel_BookNew($oExcel, 2)
                $oWorkbook2 = _Excel_BookOpen($oExcel2, $rExportPath)
                If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookNew Example 1", "Error creating new workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

                _Excel_RangeWrite ( $oWorkbook2, $oWorkbook2.Activesheet, $aRet)

                $oWorkbook2.Worksheets(1).Name = "Products"
                $oWorkbook2.Worksheets(2).Name = "Barcode Printer"

            ;   Local $sWorkbook = @DesktopDir & "\_Excel1.xlsx"

                _Excel_BookSaveAs($oWorkbook2, $rExportPath, Default, True)

I even called the excel close again just for the sake of it before this save function.

I've checked task manager to make sure there is no other excel running, and I checked the attribute and it is not readonly. This simply wont save if the excel file already exists. I expect if it's read/write it should overwrite an existing file. Am I incorrect in assuming that? The help file didn't specifically say an existing file cannot be overwritten.

 

 

Edited June 13, 2022 by Champak

[water]

What’s the value of @error and @extended after saving the workbook?

[Champak]

4, unable to delete the file. 

[dmob]

Try adding a Sleep before save?

[Champak]

@dmobNo sleep doesn't help anything.

@water I missed the @extended part, that is 0.