Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-24-2015, 12:02 PM
spc94 spc94 is offline Finding and Replacing a word with text copied to clip board Windows 7 64bit Finding and Replacing a word with text copied to clip board Office 2010 64bit
Novice
Finding and Replacing a word with text copied to clip board
 
Join Date: Jun 2015
Location: Ohio, USA
Posts: 8
spc94 is on a distinguished road
Default Finding and Replacing a word with text copied to clip board

I am trying to find a specific word and replace with text copied to my clip board. Currently I am searching the word replacing it with nothing and then pasting it there but it does seem to work correctly any suggestions.

ChangeFileOpenDirectory "X:\sconner\CCD Damage Mechanisms\Mechanisms\"
Documents.Open FileName:= _
"X:\sconner\CCD Damage Mechanisms\Mechanisms\Underdeposit Corrosion.docx", _
ConfirmConversions:=False, ReadOnly:=False, AddToRecentFiles:=False, _
PasswordDocument:="", PasswordTemplate:="", Revert:=False, _
WritePasswordDocument:="", WritePasswordTemplate:="", Format:= _
wdOpenFormatAuto, XMLTransform:=""
Selection.WholeStory
Selection.Copy
ActiveWindow.Close
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "(NEXT MECH)"
.Replacement.Text = ""
.Forward = True


.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute Replace:=wdReplaceAll
Selection.PasteAndFormat (wdUseDestinationStylesRecovery)
Reply With Quote
 

Tags
find and replace, userforms, word vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding varying text in an MS Word file sergiodcq Word 1 07-08-2014 03:12 AM
Copied shape/text box pastes as an image in Word spectator Word 0 06-04-2014 08:45 AM
Finding and Replacing a word with text copied to clip board Finding and replacing fonts and styles Adriano Word VBA 10 03-17-2013 07:08 PM
Underlined copied text box LarryStroup PowerPoint 0 09-30-2011 11:22 AM
PP Slide copied text is underlined LarryStroup PowerPoint 0 05-20-2011 11:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:15 AM.


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