Even if an Excel Workbook is opened in Readonly, on closing the question is asked to save the workbook.

[dominique]

I find it strange that when closing an Excel workbook, where as the workbook has been opened in ReadOnly mode, I  get the question to Save the workbook.

Indeed, as ReadOnly has been requested, Saving the Workbook should never happen.

This is the code where saving is always requested:

Local $oExcel = _Excel_Open(False,  False,  False,  False,  True) ; Visible, Alerts, ScreenUpdate, Interactive, ForceNew
Local $oWorkbook = _Excel_BookOpen($oExcel, "I:\BOEIC_1887_Bulletin.xls", True,  False) ; ReadOnly, Visible
_DebugOut("Workbook Saved flag =" &  $oWorkbook.Saved)
 
;$oWorkbook.Saved = True
_Excel_BookClose($oWorkbook, False) ; Save
_Excel_Close($oExcel,  False, True) ; Save, ForceClose

The only way I found to avoid the question to save is to set $oWorkbook.Saved variable to True (as in comment in example).

Then and only then I could close the a silent Workbook close

Is there a better way to force a "silent" WB close without save?

[water]

What happens when you set visibility to True in _ExcelBookOpen?

[dominique]

If I use :

Local $oExcel = _Excel_Open(True,  False,  False,  False,  True) ; Visible, Alerts, ScreenUpdate, Interactive, ForceNew

Or set the visiblity flag manually

$oExcel.Visible = True

No change, the "Save" inquiry window still appears, but now I get (only) an Excel background window (without the Workbook visible ???).

 

 

[water]

I'm unable to reproduce your problem!

Which version of Excel do you run?
Could you translate your XLS workbook to XLSX and test again?

[ioa747]

Check if your file has formula functions (e.g. =NOW(), =TODAY(), =RAND()), which are recalculated when the file is opened.

Edit:
$oExcel.DisplayAlerts = False  ; Force silent close

 

Edited 1 hour ago by ioa747

[donnyh13]

I wonder if a field is automatically updating? In LibreOffice Calc at least, fields/formulas still can update even in Read-Only mode. Which would still set the modified status to True.

Is there a way to open the workbook without Auto-Update of fields?

Edit: @ioa747 beat me to it.

Edited 1 hour ago by donnyh13

[dominique]

Office16 alias Excel 2021

However, that xls had VBA functions and VBA Forms.

Using xlsx instead xls avoids that query window when closing the Workbook.

But

using the xls, stripped from the VBA procedures and Forms also solves this issue without the trick

$oWorkbook.Saved = True

 

FYI in attachment the xls giving the problem.

 

BOEIC_1887_Bulletin.xls