Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 10-14-2021, 09:49 PM
Guessed's Avatar
Guessed Guessed is offline Using Find & Replace in Word instead of GREP Function in Adobe Indesign Windows 10 Using Find & Replace in Word instead of GREP Function in Adobe Indesign Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,187
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

If you want a demo file you should create it and post it here. Then I can make the macro work according to what you actually have rather than what I think you might have. I presume you don't want code for a single input line but that is all you have provided.

The code I posted assumes the text you posted in https://www.msofficeforums.com/163102-post1.html is the first paragraph of a Word document. The code takes just this one paragraph's text as the input and converts it into an array with a new item every time the string contains a ". Then it grabs the text from the positions in that array that align with your required data values. These array positions are the numbers you see in the sOutput line.

In my code, the output appears in your vba Immediate Window. If you want to do something else with it then you need to explain what exactly that is. The three disabled lines in the code (the lines with the ' at the start of the line) output each of the array positions to the Immediate Window so you can work out what numbers align with the data you require.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 

Tags
find & replace, find replace;wildcards, word vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Some text are missing while importing into Adobe InDesign Muthukumaran Word 2 07-23-2019 11:30 PM
Using Find & Replace in Word instead of GREP Function in Adobe Indesign Function in a Macro used to Find & Replace koehlerc14 Word VBA 3 02-15-2019 11:59 AM
Using Find & Replace in Word instead of GREP Function in Adobe Indesign Find and Replace function shooting off screen to the left of the document Mattblack Word 1 04-10-2014 03:06 PM
Indesign Table to MS word for Editing Kathy Neal Word Tables 1 01-15-2013 07:56 AM
Using Find & Replace in Word instead of GREP Function in Adobe Indesign Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM

Other Forums: Access Forums

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