You can show the built-in dialog with a different file type, but I don't
think that is what you are asking.

For example:

Application.Dialogs(xlDialogSaveAs).Show , 3

will show .txt as the default extension.

But AFAIK there is no way to change the default file type permanently.
__________________________________________________ _______________________

"Greg Lovern" wrote in message
oups.com...
Without removing and replacing Excel 2003's File Save As menu command,
is there any possibility of changing the default file type in Excel's
Save As dialog?

What about in Excel 2007?

I understand how to do it with a custom Save As procedure using
GetSaveAsFileName, just need to know if anything can be done with
Excel's built-in Save As.


Thanks,

Greg