xlDialogSaveAs
 

My clients want to be able to use the Excel Popup Dialog
box from my code, that way, if they want to change the
location and document name, they can. However, I've tried
every example I've seen, the below one comes right from
Microsoft but when I run it, the Dialog box is sitting on
my Desktop, and the File Type is a CSV. ???
To create a macro (SaveDialogFile) that will start the
Save As dialog box and select a specific file name and
path, use the following Visual Basic sample code:
Sub SaveDialogFile()
Application.Dialogs(xlDialogSaveAs).Show
("<drive:\<path\<filename")
End Sub

Help??!!