| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for save as
Application.Dialogs(xlDialogSaveAs).Show arg2:=xlTextWindows
There are lots of text files: xltextmac xltextmsdos xltextprinter xltextwindows xlunicodetext xlcsv xlcsvmac xlcsvmsdos xlcsvwindows ps. The parms for that SaveAs dialog a xlDialogSaveAs document_text, type_num, prot_pwd, backup, write_res_pwd, read_only_rec (taken from VBA's help for dialogs) The constants came from VBA's help for xlfileformat/Microsoft Excel Constants. deeds wrote: I have a macro with this at the end... Application.Dialogs(xlDialogSaveAs).Show however, I want the "save as type" at the bottom of the "Save as box" to default to .txt Thanks in advance... -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Save without the Save Message | Excel Discussion (Misc queries) | |||
| "Save" macro problem, still prompted to save when closing workbook (?) | Excel Programming | |||
| Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
| ASP: Open Excel File with Macro, Allow Macro to run, and then save | Excel Programming | |||
| Prompted to save changes after macro save - why? | Excel Programming | |||
Threaded Mode
