Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-03-2015, 07:43 AM
AlexandarR AlexandarR is offline How to insert comments thro' macro Windows XP How to insert comments thro' macro Office 2003
Novice
How to insert comments thro' macro
 
Join Date: Mar 2015
Location: Chennai, Tamilnadu, India
Posts: 7
AlexandarR is on a distinguished road
Smile How to insert comments thro' macro

It works excellent!!!



Thank you very much!!!
Reply With Quote
  #2  
Old 03-15-2015, 11:01 AM
AlexandarR AlexandarR is offline How to insert comments thro' macro Windows XP How to insert comments thro' macro Office 2003
Novice
How to insert comments thro' macro
 
Join Date: Mar 2015
Location: Chennai, Tamilnadu, India
Posts: 7
AlexandarR is on a distinguished road
Thumbs up Macro to find a text and format it, adding a comment

Quote:
Originally Posted by AlexandarR View Post
It works excellent!!!

Thank you very much!!!

Hi! This Alex again!

I have modified the code slightly, to change the colour and not to replace anything.

code:

Sub z_Abstract()
Dim vFindText As Variant
Dim sReplaceText As String
Dim oRng As Range
Dim oSearch As Range
Dim oFound As Range
Dim i As Long
Dim sAsk As String
Options.DefaultHighlightColorIndex = wdTurquoise
vFindText = Array("I", "we", "us", "our")
sReplaceText = "zzzzz"
Set oRng = ActiveDocument.Range
With oRng.Find
Do While .Execute(FindText:="\<ABS\>*\<\/ABS\>", MatchWildcards:=True)
Set oSearch = oRng
For i = 0 To UBound(vFindText)
Set oFound = oSearch
With oFound.Find
Selection.Font.Color = wdColorPink
.ClearFormatting
.Replacement.ClearFormatting
.MatchWholeWord = True
Do While .Execute(FindText:=vFindText(i), _
MatchWholeWord:=True, _
MatchWildcards:=True, _
Forward:=True, _
Wrap:=wdFindStop) = True
'oFound.Text = sReplaceText

oFound.HighlightColorIndex = wdTurquoise
oFound.Font.Color = wdColorPink
oFound.Comments.Add oFound, "CE: The use of personal pronouns (I, we, us, our) is not permitted in the abstract."
oFound.Collapse wdCollapseEnd
If oFound.End >= oSearch.End Then Exit Do
Loop
End With
Next i
Loop
End With
lbl_Exit:
Exit Sub
End Sub

That code finds in order of the array only. i.e. In the following text, the macro finds the text in array only in the same order and it finds a text once only.

<ABS>The use of personal pronouns (our, us, I, we) is not permitted in the abstract. The use of personal pronouns (I, we, us, our) is not permitted in the abstract.

I need to find all occurrences of a [whole] word irrespective of the order, within the coded text.

Please help.

Thanks!
Reply With Quote
Reply

Tags
insert comment, vba macro



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to insert comments thro' macro How to Insert more criteria in Macro shilabrow Excel Programming 4 06-23-2014 08:16 AM
Macro to insert Text Morte Excel Programming 1 03-04-2014 04:33 PM
How to insert comments thro' macro Macro to insert picture in footer Sharon Word 5 01-29-2013 03:12 AM
Macro to insert new page... samanthaj Word 17 01-31-2012 01:53 PM
How to insert comments thro' macro Macro for Picture Insert rfhall50 Word VBA 2 10-25-2010 12:41 PM

Other Forums: Access Forums

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