Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dialogs Command
I'd like to make a built-in dialogs command take an
argument to save a file as a tab-delimited text file. Here's my code, with "SIMONFile" being the string variable holding the file name: Application.Dialogs(xlDialogSaveWorkbook).Show SIMONFile When I run this, the built-in dialog box defaults to an .xls file. Is it possible to use a built-in dialog and change the default to a .txt file? I know how to use the Workbook.SaveAs command to make this happen, but I'd like to use the built-in dialog. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dialogs | Excel Discussion (Misc queries) | |||
Named arguments for built in dialogs | Excel Programming | |||
Excel's built-in dialogs | Excel Programming | |||
Using Dialogs Save | Excel Programming | |||
Windows Common Dialogs in VBA? | Excel Programming |