Find paragraph matching an expression in Word and exporting to Excel spreadsheet

ballpoint · #1 11-03-2017, 08:38 AM

Hi all,

I am looking to find a way to do the following, which I am not sure is even possible in Word / Excel. I tried to find a solution, but so far failed. Basically, I would need to:

Search for the instances in which a particular word / expression / regex occurs in
2) several word files in a folder
Find the matching paragraphs and copy them
Paste them in an excel spreadsheet

Ideally, the resulting spreadsheet would have the name of the document in the first column, the search operator I used in the second, and the matching paragraphs in the third. Something like this, to be clear:

Code:

Document | Operator | Text

Doc 1       | Operator1| Matching text
Doc 2       | Operator1| Matching text

Is there any way to accomplish any of that?

Thank you very much!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet	Labyrinth	Word	7	07-19-2016 01:35 PM
Exporting quiz scores from powerpoint to excel spreadsheet/word	rjagile	PowerPoint	1	02-08-2016 02:26 PM
Find and replace in word document repeated for every item in excel spreadsheet	Daniell	Word	1	02-17-2015 04:38 AM
Trying to import specific data from one spreadsheet to another, without matching rows	Wynka	Excel	0	11-26-2014 09:33 AM
Macro: Exporting Data to a LEGIBLE Excel Spreadsheet	jeffcoleky	Word VBA	6	05-08-2012 08:24 AM