Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-01-2020, 10:28 AM
Leslie Leslie is offline Find and Replace whole folder content - Word files Windows 8 Find and Replace whole folder content - Word files Office 2010
Novice
Find and Replace whole folder content - Word files
 
Join Date: Oct 2019
Posts: 13
Leslie is on a distinguished road
Default Find and Replace whole folder content - Word files

Much pretty sure about getting solution from this forum!

Got a code, and the code needs execution so that the pointed folder, containing Word files, completely 'Find and Replace' the files' content in whole.

Much obliged if the below code gets optimized too (quick execution)!
Below is the F/R code:


Code:
Sub FindAndReplaceMultiItems()
  Dim strFindText As String
  Dim strReplaceText As String
  Dim nSplitItem As Long
   
  Application.ScreenUpdating = False

  strFindText = "northenn,westenn"
  strReplaceText = "northern,western"
  
  nSplitItem = UBound(Split(strFindText, ","))

  ' Find each item and replace it with new one respectively.
  For nSplitItem = 0 To nSplitItem
    With Selection
      .HomeKey Unit:=wdStory
      With Selection.Find
        .ClearFormatting
        .Replacement.ClearFormatting
        .Text = Split(strFindText, ",")(nSplitItem)
        .Replacement.Text = Split(strReplaceText, ",")(nSplitItem)
        .Format = False
        .MatchWholeWord = False
      End With
    Selection.Find.Execute Replace:=wdReplaceAll
  End With
Next nSplitItem

  Application.ScreenUpdating = True

MsgBox "DONE EXECUTION"
End Sub
Thanks.

Last edited by Leslie; 03-01-2020 at 11:07 AM. Reason: added description
Reply With Quote
 

Tags
macro, multiple find and replace



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace whole folder content - Word files Static Folder Locations to Automate a Find and Replace using Word VBA rmoyar Word VBA 9 01-29-2020 02:35 PM
Need to find/replace text in many word files - but text is in embedded word files semple.13 Word VBA 5 11-03-2015 01:20 PM
Find and Replace whole folder content - Word files Find & replace footer text in a folder of Word 2010 documents kennethc Word 3 03-28-2015 02:49 AM
Find and Replace whole folder content - Word files VBA Batch Find & Replace for all MSOffice extensions, to replace File Name and Content of the File QA_Compliance_Advisor Word VBA 11 09-11-2014 11:51 PM
Macro to replace SSN in all files within a folder caj1980 Word VBA 7 09-11-2014 04:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:04 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