Thread: [Solved] Word macro question
View Single Post
 
Old 08-26-2015, 10:42 AM
mpd mpd is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Aug 2015
Location: Cincinnati
Posts: 3
mpd is on a distinguished road
Default Word macro question

I'm putting together a word macro with the ultimate goal of upon execution the macro looping through all rtf files in a folder and saving them as docs. In it's current state the macro loops through the files as expected. However i'm required to click the save button for each file. Ideally it would automatically take care of this. Any guidance would be greatly appreciated. Here's the macro in it's current state:

Code:
Sub RTFtoDOC()
Dim FName As String
Dialogs(wdDialogFileOpen).Show
Application.ScreenUpdating = False
FName = Dir("*.rtf")
While (FName > "")
  Application.Documents.Open FileName:=FName _
  , ConfirmConversions:=False, ReadOnly:=False, AddToRecentFiles:=False, _
  PasswordDocument:="", PasswordTemplate:="", Revert:=False, _
  WritePasswordDocument:="", WritePasswordTemplate:="", Format:= _
  wdOpenFormatAuto, XMLTransform:="", Encoding:=1252
  ActiveDocument.SaveAs FileName:=FName, FileFormat:=wdFormatDocument
  ActiveDocument.Close
  'SaveChanges:=wdSaveChanges
  FName = Dir()
Wend
Application.ScreenUpdating = True
End Sub

Last edited by macropod; 08-26-2015 at 05:04 PM. Reason: Added code tags & formatting
Reply With Quote