I am saving a .csv to a .xls and regardless of what method I use to save it in a macro there are quote marks around the filename in the dialog box. This only appears to happen if I start with a .csv as I have tested it with a .xls and there is no issue. I have tried using the following code so far.
![]()
Application.Dialogs(xlDialogSaveAs).Show (WkbkName)
![]()
FileSaveName = Application.GetSaveAsFilename(fileFilter:="Excel Files (*.xls), *.xls")
Bookmarks