<div>
Alternatively when you close the workbook, set the value of 'Save' as 'False' so it won't prompt you whether DisplayAlerts is True or False.<br />
<br />
For example<br />
<br />

<pre><code id="code-20-35294783-1">oBook.Close SaveChanges:=False</code></pre>
<br />
Where oBook is the workbook object.<br />
<br />
Sid
</div>


<div>
<div class="content wysiwyg-content">
I have a app that opens and reads Excel files and updates another data file (non Excel). With Excel 2003 and 2007, this worked well. &nbsp;Now with Excel 2010, my app opens the Excel file and does 4 data reads. For each read Excel is asking the user 'do you want to save the file'. The user has to click 'No&quot; four times to get though the process. <br />
<br />
The target Excel files are created by Excel 2003 components. These files are successfully read &nbsp;by my app when excel 2007 is installed. &nbsp;(First time in Excel 2010 setup). <br />
<br />
All of this is under windows 7.<br />
What settings in Excel would cause/help this? <br />
<br />
Thanks,<br />
Don <br />
<br />

</div>
</div>


I have a app that opens and reads Excel files and updates another data file (non Excel). With Excel 2003 and 2007, this worked well.  Now with Excel 2010, my app opens the Excel file and does 4 data reads. For each read Excel is asking the user 'do you want to save the file'. The user has to click 'No" four times to get though the process. 

The target Excel files are created by Excel 2003 components. These files are successfully read  by my app when excel 2007 is installed.  (First time in Excel 2010 setup). 

All of this is under windows 7.
What settings in Excel would cause/help this? 

Thanks,
Don 



Alternatively when you close the workbook, set the value of &#39;Save&#39; as &#39;False&#39; so it won&#39;t prompt you whether DisplayAlerts is True or False.

For example

(CODE)

Where oBook is the workbook object.

Sid

In Excel 2010, how to stop Excel asking th euser to save the file every time the file is read ; is there a security setting.

I have a app that opens and reads Excel files and updates another data file (non Excel). With Excel 2003 and 2007, this worked well.  Now with Excel 2010, my app opens the Excel file and does 4 data reads. For each read Excel is asking the user &#39;do you want to save the file&#39;. The user has to click &#39;No&quot; four times to get though the process. 

The target Excel files are created by Excel 2003 components. These files are successfully read  by my app when excel 2007 is installed.  (First time in Excel 2010 setup). 

All of this is under windows 7.
What settings in Excel would cause/help this? 

Thanks,
Don 



Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.