Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-06-2010, 01:27 AM
jabberwocky12 jabberwocky12 is offline Word Macro: Save file as text with current file name Windows 7 Word Macro: Save file as text with current file name Office 2007
Novice
Word Macro: Save file as text with current file name
 
Join Date: Sep 2010
Posts: 2
jabberwocky12 is on a distinguished road
Default Quick Update

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

-----
Reply With Quote
 



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
Word Macro: Save file as text with current file name 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
Word Macro: Save file as text with current file name File conversion Warning Box On Save ding dong Word 9 04-12-2009 05:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft