Hi

Application.Dialogs(xlDialogSaveAs).Show (Format(Date, "yymmdd") &
"xxx.xls")

HTH. Best wishes Harald

"Leslie" <leslieunderscorekatz@agddotnswdotgovdotau skrev i melding
...

Application.Dialogs(xlDialogSaveAs).Show ("xxx.xls"). That also worked for
Excel 2002, I found.

However, is there a way in which I can have that box prompt me to save the
file with the date part of the file name already being whatever is the
current date?