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?

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?

Bob,

Thanks for the idea, but I've tried that. The problem I have with
GetSaveAsFilename is the FileFilter. I cannot find a way to build the same
list as Excel uses with all of the billions of saveas types. Any idea how to
do this? And, if I can get this, how do I map the saveas type to the correct
FileFormat?

"Bob Phillips" wrote:

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?