Macro SaveAs - Date format

[jonnyhbgood]

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)

"jonnyhbgood" <jonnyhbgood@discussions.microsoft.com> wrote in message
news:3A6C40C9-4EA1-49DA-BF17-20F5F44BE8A1@microsoft.com...
> 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?

[jonnyhbgood]

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" <jonnyhbgood@discussions.microsoft.com> wrote in message
> news:3A6C40C9-4EA1-49DA-BF17-20F5F44BE8A1@microsoft.com...
> > 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?
>
>
>