Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 01-11-2022, 04:32 PM
Mr J Mr J is offline Looking for VBA code that can FIND and SELECT any text based on its properties Windows 10 Looking for VBA code that can FIND and SELECT any text based on its properties Office 2016
Novice
Looking for VBA code that can FIND and SELECT any text based on its properties
 
Join Date: Aug 2020
Location: California, US
Posts: 15
Mr J is on a distinguished road
Default

My initial thought was bringing all the manual covers into one document then running a search to extract all the titles was the easiest solution. Technically removing everything that is “not a title” would also work but making that code seemed more complicated. I would totally use that if someone could show me how to write that. As for the properties, I thought that was a reasonable search to isolate the text that makes up the title because that would also be a constant between all the different manual title (Without grabbing other text). Honestly I probably don’t need all those properties, I was mostly using them as an example, but I would also like to learn how so I can get better and creating the codes myself.

I’m not too familiar with the Table of Content coding, is that something I can automate or would I have to add it each time I run it on a new set of manuals? If it will give me a list that I can paste into an Excel column for a comparison I am totally on board!

Edit: Forgot to mention, the only reason I was moving everything onto a new page was so I could just CTRL+A, CTRL+C, then paste in Excel. Plus seeing it on a new sheet I would be able to see it all layed out with everything on it's own row. so I can see if any other text was grabbed by mistake. I already have a similar macro that can copy anything that is highlights and add it to a new document, but as you know I am having trouble finding a way to get the text that makes up the title highlighted.

Last edited by Mr J; 01-11-2022 at 04:45 PM. Reason: Forgot to mention
Reply With Quote
 

Tags
macro find text, select text, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro/VBA code to select ALL text in a textbox in microsoft excel and add a new row jyfuller Excel Programming 11 06-01-2015 08:49 PM
Macro to select an { includepicture } field code and format the picture behind text and 100% scale sanpedro Word VBA 3 03-30-2015 10:50 PM
Microsoft Word macro to find text, select all text between brackets, and delete helal1990 Word VBA 4 02-05-2015 03:52 PM
Looking for VBA code that can FIND and SELECT any text based on its properties VBA code for Microsoft Word macro — select text and insert footnote ndnd Word VBA 10 01-06-2015 01:47 PM
Looking for VBA code that can FIND and SELECT any text based on its properties How to find and select text in a document? mkhuebner Word VBA 8 02-04-2014 08:04 PM

Other Forums: Access Forums

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