The outcomes I'm trying to achieve through a macro
- prompts user to pick a location to save (i.e. the save dialog box)
- defaults file type to CSV.

Unfortunately I can't seem to do this in a single piece of code
Code 1:Application.Dialogs(xlDialogSaveAs)
Does: allow user to pick location
Does not: default to CSV in filetype

Code 2:ActiveWorkbook.SaveAs Filename:=strFileName, _
FileFormat:=xlCSV, _
CreateBackup:=False
(strfilename is a string i use to name the sheet based on cell locations)
Does: save as CSV
Does not: allow user to pick location (defaults to a current path)

So hoping for some ideas on how I can get best of both codes! I've had a think about the "chdir" option but the limitation of that is the inability to specify a universal location across the users. For e.g. "Desktop" is drive:/documents and settings/<xpid> of user /Desktop

Many Thanks!