Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change default Save As file type
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change default Save As file type
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change default Save As file type
I would guess it could be done with subclassing, though it might not
be worth the development time. Are there any examples available of subclassing Excel's Save As dialog? Also, I recall reading that 64-bit Windows Vista would drop support for subclassing -- is that correct? Thanks, Greg On Jul 6, 5:36 pm, "Vasant Nanavati" <vasantn AT aol DOT com wrote: 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- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a .XLTM template file default to save as .XLSM type? | Excel Discussion (Misc queries) | |||
default save as file type does not work | Excel Discussion (Misc queries) | |||
how do i change the default number type which is formatted in new. | Excel Discussion (Misc queries) | |||
How do I change file/open/"files of type" to default to "all file. | Excel Discussion (Misc queries) | |||
change default file path in Save As dialog box | Excel Programming |