<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
This is the code I tried but can't get to work:<br />
<br />
sFileSaveName=ThisWorkbook<wbr />.Range(&quot;rF<wbr />ileName&quot;).<wbr />value<br />
<br />
With Application.Dialogs(xlDial<wbr />ogSaveAs)(<wbr />&quot;C:\RootFo<wbr />lder\Subdi<wbr />r\&quot; &amp;&nbsp;sFileSaveName)<br />
&nbsp; &nbsp; .Show<br />
End With<br />
<br />
Thanks, --Andres
</div>
</div>


This is the code I tried but can't get to work:

sFileSaveName=ThisWorkbook.Range("rFileName").value

With Application.Dialogs(xlDialogSaveAs)("C:\RootFolder\Subdir\" & sFileSaveName)
    .Show
End With

Thanks, --Andres

Excel VBA - How to prompt user to save wkbook w/ specific name &amp; location

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

Excel VBA - How to prompt user to save wkbook w/ specific name &amp; location

Excel VBA - How to prompt user to save wkbook w/ specific name & location