VBA to Extract Specific table data from multiple words to one excel worksheet

Hi Team,

I have the below request: Extract specified tables from multiple words to one excel worksheet

1. Open multiple word files one after other
2. Copy tables from the word files with a pre defined column headers (not all tables). There are several such tables in a single word file itself that needs to be copied.
3. Create a "Master" Worksheet and paste the tables. Include the file name as a starting column for recognizing the data from which file is copied.
4. Close the opened word files without saving and move to the next word file in the folder.

Thank you so much
Shan

Any response on this request please?

Here is my working vba. Additionally I want the Heading & Sub Heading details to be added next to the table where the table was present in the word file. Attaching the word file for reference and trial. /Option Explicit

Please Login or Register  to view this content.