<div>
<pre><code id="code-20-35096513-1">application.dialogs(xlDialogSaveAs).Show &quot;C:\test&quot;</code></pre>
you can add a filename as well if required.
</div>


application.dialogs(xlDialogSaveAs).Show "C:\test"

you can add a filename as well if required.

<div>
This works great, but I also need it to default the Save as Type combobox toshow *.xls.<br />
<br />
Is that possible?
</div>


This works great, but I also need it to default the Save as Type combobox toshow *.xls.

Is that possible?

<div>
It is absolutely perfect!<br />
<br />
Thank you
</div>


<div>
<div class="content wysiwyg-content">
From Excel, I have written VBA code that will save a file with a predetermined filename. &nbsp;<br />
<br />
If that filename already exists, I need VBA to open the SaveAs dialog window and supply a suggested filename.<br />
<br />
How do I open the SaveAs dialog with VBA code?<br />
<br />

</div>
</div>


From Excel, I have written VBA code that will save a file with a predetermined filename.  

If that filename already exists, I need VBA to open the SaveAs dialog window and supply a suggested filename.

How do I open the SaveAs dialog with VBA code?



Open the SaveAs dialog with VBA in Excel

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