Macro SaveAs - Date format
 

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?

Macro SaveAs - Date format
 

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?

Macro SaveAs - Date format
 

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?