<div>
Hi,<br />
<br />
pls try
<pre><code class="code-1 nolinks" id="code-20-42385570-1"><span> Filename = Application.GetSaveAsFilename( _ </span>
<span>    fileFilter:=&quot;Excel Files (*.xls), *.xl&quot;) </span>
<span>    If Filename &lt;&gt; False Then </span>
<span>        ActiveWorkbook.SaveAs Filename </span>
<span>    End If </span>
</code></pre>
Regards
</div>


<div>
Hi<br />
<br />
Thanks for the help, this works. At the moment its saving the current Workbook and I need to create a new empty workbook but I'll see if I can get it working. Thanks for the help
</div>


<div>
That worked a treat, thank you Rgonzo
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I'm working on a VBA application and would like to let the user create a new Workbook and choose where to save it using the well know Windows Dialog boxes. I can find examples of msoFileDialogFilePicker so select a file or another method for selecting a folder but couldn't see anything to actually save a new Workbook. Could someone point me in the right direction if they know.<br />
<br />
Thanks
</div>
</div>


Hi

I'm working on a VBA application and would like to let the user create a new Workbook and choose where to save it using the well know Windows Dialog boxes. I can find examples of msoFileDialogFilePicker so select a file or another method for selecting a folder but couldn't see anything to actually save a new Workbook. Could someone point me in the right direction if they know.

Thanks

VBA Use Windows File Dialog Box to Create a Workbook

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.