Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-29-2017, 09:23 PM
Helend269 Helend269 is offline How do I search a doc and run code on finding a word? Windows 7 32bit How do I search a doc and run code on finding a word? Office 2003
Novice
How do I search a doc and run code on finding a word?
 
Join Date: Aug 2017
Posts: 15
Helend269 is on a distinguished road
Default

Thanks but I can't quite get it to work as I want it to. Perhaps I'd better explain what I want to do. I have something like this:

Random line that stays as it is.
TRIGGER LINE
This text to be made uppercase
Random line that stays as it is.
Random line that stays as it is.
Random line that stays as it is.
TRIGGER LINE
This text to be made uppercase
Random line that stays as it is.
Random line that stays as it is.
Random line that stays as it is.

I have a small bit of code from recording a macro that goes down one line from the TRIGGER LINE, selects the line where the cursor now is and makes it uppercase.

The problem is I have 3,000-odd instances of the TRIGGER LINE so I need to automate it.

The code I have to do this is:

Selection.MoveDown Unit:=wdLine, Count:=1
Selection.HomeKey Unit:=wdLine
Selection.EndKey Unit:=wdLine, Extend:=wdExtend
Selection.Font.AllCaps = True
Selection.HomeKey Unit:=wdLine

I just need to be able to have something that searches for each instance of the text TRIGGER LINE and then runs my code. It would then move on to the next instance of TRIGGER LINE and repeat until the end of the document.

When I tried to put my code in your code it uppercased everything. It wasn't clear to me which part sof your code were interchangeable.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook search not finding recent mail; rebuild ix did nothing PeterA Outlook 0 01-19-2017 12:27 AM
How do I search a doc and run code on finding a word? Need some vba code to search a word document an replace it if len = 3 Belleke Word VBA 3 10-24-2016 01:00 AM
How do I search a doc and run code on finding a word? Finding more than one word using "find" or using a vba code capitala Word VBA 1 02-03-2014 06:45 PM
How do I search a doc and run code on finding a word? Outlook 2010 Search not finding all items gdrunner Outlook 2 03-10-2013 06:48 PM
Outlook 2010 search not finding everything rexracer Outlook 5 07-21-2011 02:31 AM

Other Forums: Access Forums

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