how to change default file name in "save as" or "save"

  • Thread starter Thread starter gerard
  • Start date Start date
G

gerard

Hello
could you tell me how to change the default file name in
the dialog "save as" or "save" without opening the dialog
or save the file
tks in advance..... I am really stucked....
 
I don't think you can do this

But you can use this

FName = Application.GetSaveAsFilename("yourfilename", _
fileFilter:="Excel Files (*.xls), *.xls")

See the VBA help for GetSaveAsFilename to get more information
 
Back
Top