<div>
There is nothing in your code that would trigger a dialog unless your filename is missing or you are using a function to provide the file name.
</div>


There is nothing in your code that would trigger a dialog unless your filename is missing or you are using a function to provide the file name.

<div>
<div class="content wysiwyg-content">
I'm trying to my workbook using a macro, I don't want any prompts to show up.<br />
<br />
I'm using the command... &nbsp; &nbsp; &nbsp; &nbsp;<br />

<pre><code id="code-10-27854156-1">ActiveWorkbook.SaveAs Filename:=&lt;FILEPATH&gt;</code></pre>
However the save as dialog box is shown each time.<br />
<br />
I've read about adding DisplayAlerts command before and after the saveas command<br />

<pre><code id="code-10-27854156-2">Application.DisplayAlerts = False
Application.DisplayAlerts = True</code></pre>
But the save as dialogue still keeps popping up!
</div>
</div>


I'm trying to my workbook using a macro, I don't want any prompts to show up.

I'm using the command...        
(CODE)
However the save as dialog box is shown each time.

I've read about adding DisplayAlerts command before and after the saveas command
(CODE)
But the save as dialogue still keeps popping up!

Excel 2010 VBA SaveAs No dialog/Prompt

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