Thread: how to change default file name in "save as" or "save"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default how to change default file name in "save as" or "save"
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

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"gerard" wrote in message ...
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....


Reply With QuoteReply With Quote