Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for save as
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for save as
On Oct 28, 5:18 pm, 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... Look at the Application.GetSaveAsFilename function. You can set several parameters. The short side is that this only returns the filename and does not acturally save the file. You would have to use something like Scripting.TextStream (in Microsoft Scripting Runtime) |
#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 |
Reply |
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 |