![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
I am a macro novice and am trying to come up something that does the following in MS Word:
1) Paste the contents of the clipboard as plain text (into a Word document). 2) Find and replace all instances of <, >, and # with a dash. 3) Copy the resulting text back to the clipboard. I found the following snippet online and it accomplishes steps 1-2 above, but I can't figure out how to copy the results back to the clipboard (Step 3). I am trying to use "ContentControl.Copy" but not sure where to add it into the existing code. Thanks in advance for your help! Code:
Sub FindReplaceAll()
Selection.Collapse Direction:=wdCollapseStart
Selection.PasteSpecial DataType:=wdPasteText
Dim StrFind As String, StrRepl As String
Dim FindItem As String, ReplaceItem As String
Dim i As Long
Dim aNote As Endnote
StrFind = "<,>#"
StrRepl = "-,-,-"
Set RngTxt = Selection.Range
For i = 0 To UBound(Split(StrFind, ","))
FindItem = Split(StrFind, ",")(i)
ReplaceItem = Split(StrRepl, ",")(i)
Selection.HomeKey wdStory
Selection.Find.ClearFormatting
With Selection.Find
.ClearFormatting
.Replacement.ClearFormatting
.Text = FindItem
.Replacement.Text = ReplaceItem
.Format = False
.MatchWholeWord = True
.MatchAllWordForms = False
.MatchWildcards = False
.Execute Replace:=wdReplaceAll
End With
For Each aNote In ActiveDocument.Endnotes
With aNote.Range
.Find.Execute FindText:=FindItem, ReplaceWith:=ReplaceItem, Replace:=wdReplaceAll
End With
Next aNote
Next i
End Sub
Last edited by macropod; 01-02-2025 at 01:18 PM. Reason: Added code tags & corrected formatting |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| paste from clipboard to selected paragraphs | yacov | Word VBA | 5 | 02-04-2024 01:41 PM |
Replicate the copy/paste function, without involving the clipboard
|
alex100 | Word VBA | 8 | 11-09-2020 08:19 AM |
| Need to copy specific formated text from Word and paste from clipboard into a console application | Userx | Word VBA | 0 | 10-09-2020 05:58 AM |
| Error with Clipboard - Getting Spaces Out of Clipboard | StephenRay | Word VBA | 14 | 09-27-2017 01:07 PM |
Find & selected paras with highlighted text & copy to clipboard
|
marceepoo | Word VBA | 1 | 09-14-2012 08:20 PM |