![]() |
#2
|
||||
|
||||
![]()
For some code to get you started, try:
Code:
Sub AutoTranslation() Application.ScreenUpdating = False Options.DefaultHighlightColorIndex = wdYellow Dim DocSrc As Document, DocTgt As Document, Tbl As Table, r As Long With Application.FileDialog(FileDialogType:=msoFileDialogFilePicker) .Title = "Select the source document containing the Find/Replace Table" .AllowMultiSelect = False If .Show = -1 Then Set DocSrc = Documents.Open(.SelectedItems(1), ReadOnly:=True, AddToRecentFiles:=False) Else MsgBox "No source file selected. Exiting", vbExclamation Exit Sub End If End With With Application.FileDialog(FileDialogType:=msoFileDialogFilePicker) .Title = "Select the target document to be updated" .AllowMultiSelect = False If .Show = -1 Then Set DocTgt = Documents.Open(.SelectedItems(1), ReadOnly:=False, AddToRecentFiles:=True) Else MsgBox "No target file selected. Exiting", vbExclamation DocSrc.Close SaveChanges:=False Set DocSrc = Nothing Exit Sub End If End With Set Tbl = DocSrc.Tables(1) With DocTgt With .Range.Find .ClearFormatting .Replacement.ClearFormatting .MatchWholeWord = True .MatchCase = True 'Process each word from the reference document's first table. For r = 2 To Tbl.Rows.Count .Text = Split(Tbl.Cell(r, 2).Range.Text, vbCr)(0) .Replacement.Text = Split(Tbl.Cell(r, 3).Range.Text, vbCr)(0) .Execute Replace:=wdReplaceAll Next End With .SaveAs2 FileName:=Split(.FullName, ".doc")(0) & ".rtf", Fileformat:=wdFormatRTF, AddToRecentFiles:=False End With DocSrc.Close SaveChanges:=False Set Tbl = Nothing: Set DocSrc = Nothing: Set DocTgt = Nothing Options.DefaultHighlightColorIndex = wdNoHighlight Application.ScreenUpdating = True MsgBox "Successfully replaced on the exactly matched strings" End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
word replacing |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
wardw | Word | 7 | 05-07-2018 09:13 AM |
![]() |
Amitti | Word VBA | 2 | 04-10-2017 07:35 PM |
How to find all string within string. | PRA007 | Word VBA | 18 | 02-12-2016 08:11 PM |
![]() |
omahadivision | Excel Programming | 12 | 11-23-2013 12:10 PM |
Replacing text string within document, it's not retaining formatting | livemusic | Word | 4 | 02-25-2013 12:33 AM |