| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro For Saving As .txt
I want to have a macro in my Personal Macro Workbook where I can save a .xls
file as a .txt (tab-delimited) where I can type in a new name. Please help. Thanks, Josh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro For Saving As .txt
Sub SaveAsTxt()
Dim Ans As String Ans = Application.GetSaveAsFilename("", "text files, *.Txt") If Ans < "False" Then ActiveWorkbook.SaveAs Ans End Sub "jshendel" wrote: I want to have a macro in my Personal Macro Workbook where I can save a .xls file as a .txt (tab-delimited) where I can type in a new name. Please help. Thanks, Josh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Macro | Excel Discussion (Misc queries) | |||
| Help with saving a Macro | Excel Worksheet Functions | |||
| Saving a macro | New Users to Excel | |||
| Saving with Macro | Excel Discussion (Misc queries) | |||
| Saving without Macro | Excel Discussion (Misc queries) | |||
Linear Mode
