| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a woorkbook as a TXT file keeping its current name
I'm really new to macros and I want to use a macro for several exce
files. I need to save them at the end as a Text (Tab delimited)(*.txt however I want to keep the original file name. How can I make Book1.tx a variable so it will take the woorkbook name that the macro i processing. ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\Book1.txt", FileFormat:= _ xlText, CreateBackup:=False THX -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving only current worksheet into new file | Excel Discussion (Misc queries) | |||
| Keeping lead zeros in excel text format when saving as CSV file | Excel Worksheet Functions | |||
| Saving file as current month name automatically | Excel Discussion (Misc queries) | |||
| Saving file with current date | Excel Programming | |||
| Saving a file with VBA that references current file name | Excel Programming | |||
Threaded Mode
