Can't close xls without prompting :( _Excel_Close

[Sergy]

I have price-list in xls. When I open it by _Excel_Open and _Excel_BookOpen and after that close by _Excel_Close, I have a message about "Save changes?"

I try open it in read-only mode, but no changes made. I still see annoing message.

Windows 10 prof, MS Office 2007.

 

#include <Excel.au3>
#include <MsgBoxConstants.au3>

ConsoleWrite(@AutoItVersion)

Global $sPriceFile = @ScriptDir&"\opt_pr_list-mini.xls"

Local $oExcel = _Excel_Open(False, False, False, True) 
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

Local $oWorkbook = _Excel_BookOpen($oExcel, $sPriceFile, True )     ; readonly
If @error Then
    MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead", "Error opening workbook @error = " & @error & ", @extended = " & @extended)
    _Excel_Close($oExcel)
    Exit
EndIf

_Excel_Close($oExcel, False, True)
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_Close Example 2", "Error closing the Excel application." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

Exit

What I do wrong?

Thanks.

opt_pr_list-mini.xls.zip

Edited January 7, 2017 by Sergy

[Joboy2k]

i've not tested it as not near my computer but are you sure its not closing it by the @Error  where no parameters are set?

_Excel_Close($oExcel)

[Sergy]

6 minutes ago, joboy2k said:

i've not tested it as not near my computer but are you sure its not closing it by the @Error  where no parameters are set?

_Excel_Close($oExcel)

Then I have _Excel_Close @error: 3 - Error returned by method Application.Save. @extended is set to the COM error code

And still see Excel message.

Edited January 7, 2017 by Sergy

[water]

The Excel workbook contains macros plus links to other workbooks. So the workbook always gets changed after being opened.
 

[Sergy]

Thanks! I remove all options about readonly, use _Excel_BookClose ($oWorkbook) as autosave, and all works great!

[water]