Take a look at GetSaveAsFilename in VBA help, you might have more control
over that.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jonnyhbgood" wrote in message
...
I have a european date format ("23-12-06") in a cell, and I am doing my
own
saveas in a macro. If I call Application.Dialogs(xlDialogSaveAs).Show,
and
save it in text, tab-delimited format, I get it in US format ("12-23-06").

There is a local:=True parameter that can be added to
ActiveWorkbook.SaveAs
method, but can I set this for the Show method, or intercept the save from
the Show method and get the filename and format and do it myself?