<div>
&quot;Another possibility is that you try to close the workbook and encounter the Save prompt from that action. You can avoid it with the SaveChanges parameter:<br />
wkBook.Close SaveChanges:=False&quot;<br />
<br />
You hit the nail on the head. &nbsp;This fixed the issue.<br />
<br />
Thanks.
</div>


"Another possibility is that you try to close the workbook and encounter the Save prompt from that action. You can avoid it with the SaveChanges parameter:
wkBook.Close SaveChanges:=False"

You hit the nail on the head.  This fixed the issue.

Thanks.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have the following code at the end of a function that edits an Excel spreadsheet within an Access code, VBA:<br />
<br />
apExcel.DisplayAlerts = False<br />
&nbsp; &nbsp; wkBook.SaveAs FileName:=sFileName<br />
apExcel.DisplayAlerts = True<br />
<br />
Supposedly, this should save the file without any prompts. &nbsp;Strangely, it seems to save the file, the prompt again if I want to save the prompt. &nbsp;I recently upgraded from Access and Excel 2000 to 2010, and this code worked fine with those. &nbsp;However, everything I read says this should work.<br />
<br />
Anyone have any ideas?<br />
<br />
Thanks,<br />
<br />

</div>
</div>


Hello,

I have the following code at the end of a function that edits an Excel spreadsheet within an Access code, VBA:

apExcel.DisplayAlerts = False
    wkBook.SaveAs FileName:=sFileName
apExcel.DisplayAlerts = True

Supposedly, this should save the file without any prompts.  Strangely, it seems to save the file, the prompt again if I want to save the prompt.  I recently upgraded from Access and Excel 2000 to 2010, and this code worked fine with those.  However, everything I read says this should work.

Anyone have any ideas?

Thanks,



MS Excel SaveAs Without Prompt, VBA MS Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.