Get the table details from Word to Excel

[santanukd]

Kindly provide a VBA Macro to fetch specific tables (with given column headers) from multiple word files to one excel sheet.

 

[AlanSidman]

Supply a sample Word Documents with limited data. VBA is not generic. It is specific to the situation. Then show us a mocked up solution in an excel workbook. Explain in detail which tables are to be exported. The more information, the sooner and better the solution. We are not mind readers here.

 

[santanukd]

Thanks for the suggestion, Here is a sample word file, there are several such that needs to be consolidated to excel. I want the macro to find open the word files look for tables that start with "Test Case Name" and "Description" and paste them one below other in an excel

 

[AlanSidman]

Here is a tutorial on how to get your tables into Power Query, which you can then bring into Excel after appending the tables in PQ.

Extracting data from Word (.docx) files into Power Query

redgig.blogspot.com

 

[santanukd]

A VBA will greatly help

 

[Marc L]

I want the macro to find open the word files

You must explain in order there is nothing to guess as guessing can't be coding …​

​

 

[santanukd]

I have even given now sample word and the output excel files.

 

[Marc L]

As I won't guess anything so I won't ever waste any time … Just wait for some mind reader, have a nice day !​

​

 

[santanukd]

Have a nice day Marc, Take care