Find and extract data from word and paste into Excel

Hey guys,

Got a tough problem with a document and worksheet. I have a document that has about 450 pages with parameters and values listed in exactly the same order. I need to find 4 specific variables and copy the data from the document and paste them into an excel spreadsheet. I need to find and list the Source, Parameter Type, Parameter Value, and Engineering Units. The attached document is a page from the large document. The attached workbook is how I need to have the list created. As of right now I have been copying and pasting but that takes days to do.

I can somewhat understand how a code works when it is written but I don't know where to start. Any help would be greatly appreciated.

Thanks,
Pat

I can only see 4 heading, nothing else

The information is in the attached word document.
For instance the first parameter in the document is this:
Report: Step Parameter
Name: PR_MFPL_CIP_S2/UP_CIP_S2:1/ABT_AIR_DLY_TM
Parameter Category: Process Input
Parameter Type: Integer
Low Limit: 0
Parameter Value: 10
High Limit: 9999
Engineering Units: sec
Scalable: False
Origin: Defer
Source: ABT_AIR_DLY_TM

I need to copy the Source, Parameter Type, Parameter Value and Engineering units into an excel spreadsheet. The attached workbook is just an example of how I need to list the information

Anyone???

Bueller??

LOL

hi Patrick, please check attachment, press Run button, choose file .docx with the data structure specified in the sample file posted. Basing on your sample some parameters might be absent (Engeneering Units)

Thank you so much, that it awesome works like a charm

re code: the code creates word object, opens selected document, filters out unnecessary fields leaving Report field as a delimiter between data blocks, loops the filtered data to create result data table, outputs result to Excel, kills word object.
re pdf: I don't know for now what can be done there