Macro SaveAs - Date format

[Guest]

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 Phillips]

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)

 

[Guest]

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?