![]() |
|
#4
|
||||
|
||||
|
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 |
| 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 |
Function in a Macro used to Find & Replace
|
koehlerc14 | Word VBA | 3 | 02-15-2019 11:59 AM |
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 |
Bad view when using Find and Find & Replace - Word places found string on top line
|
paulkaye | Word | 4 | 12-06-2011 11:05 PM |