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