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

[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....

 

[Ron de Bruin]

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