<div>
Thanks, your code works! &nbsp;One more question: how do I identify if the user click &quot;Cancel&quot; button in the saving window.
</div>


Thanks, your code works!  One more question: how do I identify if the user click "Cancel" button in the saving window.

<div>
I forgot to mention that the file name needs a option to be overwriiten and as Excel file
</div>


I forgot to mention that the file name needs a option to be overwriiten and as Excel file

<div>
You could check the Cancel button by checking if the fileName is False.<br />
<br />
As for your last remark: I'm not sure what you mean by 'file name needs a option to be overwritten'?<br />
Do you mean in the 'Save As' Dialog? <br />

<pre><code id="code-8091037">Sub saveTheFile()
    'get the name and folder
    Filename = Application.GetSaveAsFilename( _
        InitialFileName:=&quot;C:\yourFileName.xlsm&quot;, _
        fileFilter:=&quot;Excel Macro-Enabled Workbook (*.xlsm), *.xlsm, Excel 97 Workbook (*.xls), *.xls&quot;)
    'save if not canceled
    If Filename &lt;&gt; False Then
        Application.ThisWorkbook.SaveAs (Filename)
    End If
End Sub</code></pre>
</div>


You could check the Cancel button by checking if the fileName is False.

As for your last remark: I'm not sure what you mean by 'file name needs a option to be overwritten'?
Do you mean in the 'Save As' Dialog?


Sub saveTheFile()
    'get the name and folder
    Filename = Application.GetSaveAsFilename( _
        InitialFileName:="C:\yourFileName.xlsm", _
        fileFilter:="Excel Macro-Enabled Workbook (*.xlsm), *.xlsm, Excel 97 Workbook (*.xls), *.xls")
    'save if not canceled
    If Filename <> False Then
        Application.ThisWorkbook.SaveAs (Filename)
    End If
End Sub

<div>
<div class="content wysiwyg-content">
I need create a save button for saving the file with a suggested name in the file name box but being able to choose where they want to save and have the default to C:\drive<br />
<br />
Sub btnSave_Click()<br />
.....<br />
.....<br />
<br />
End Sub
</div>
</div>


I need create a save button for saving the file with a suggested name in the file name box but being able to choose where they want to save and have the default to C:\drive

Sub btnSave_Click()
.....
.....

End Sub

How to code to save a file with a suggested name and in a selected folder

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.

Microsoft Applications

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