![]() |
|
#2
|
|||
|
|||
|
After hunting through various snippets of code, I have done this:
Dim sNewFileName As String sNewFileName = ActiveDocument.FullName sNewFileName = sNewFileName + ".txt" Then, where the file is saved, instead of: ActiveDocument.SaveAs FileName:="1.txt" I have: ActiveDocument.SaveAs FileName:=sNewFileName These lines get the current file name and add the extension ."txt" to it. At this stage, it looks messy, cos the file is then saved as "1.doc.txt" but I have a small freeware package that does batch file renaming, so it's easy to strip that ".doc" from it. So, the whole macro (including convertin it to text and closing the window), now looks like this: --- Sub SaveAsText() ' ' SaveAsText Macro ' ' Dim sNewFileName As String sNewFileName = ActiveDocument.FullName sNewFileName = sNewFileName + ".txt" Selection.Rows.ConvertToText Separator:=wdSeparateByTabs, NestedTables:= _ True ActiveDocument.SaveAs FileName:=sNewFileName, _ FileFormat:=wdFormatText, LockComments:=False, Password:="", _ AddToRecentFiles:=True, WritePassword:="", ReadOnlyRecommended:=False, _ EmbedTrueTypeFonts:=False, SaveNativePictureFormat:=False, SaveFormsData _ :=False, SaveAsAOCELetter:=False, Encoding:=65001, InsertLineBreaks:= _ False, AllowSubstitutions:=False, LineEnding:=wdCRLF ActiveWindow.Close ----- |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Macro will not save to normal.dot file when exiting | bobbraun | Word | 1 | 09-28-2010 06:26 AM |
Save/Send to file
|
Dawn1231a | Outlook | 1 | 08-05-2010 01:10 PM |
| linking a word file and an excell file on a macbook pro | Fleur | Office | 0 | 07-14-2010 08:19 PM |
| Runtime error 5487 - Word cannot complete the save to to file permission error | franferns | Word | 0 | 11-25-2009 05:35 AM |
File conversion Warning Box On Save
|
ding dong | Word | 9 | 04-12-2009 05:46 AM |