Extract All Tables From a Word Document Into Excel

[Excel4444]

I am looking to extract only tables from a ms word document. See attached workbook for examples and further details.

The challenge with my current method is that with most (if not all) code for taking tables from word to excel, there's an alignment issue with headers. I have my own code to deal will all the merged and misaligned data in the body of the table, but without the headers in some pattern their original state cannot be put back together. I've looked through other code example such as (see below) and the list goes on, but none remedy the header issue. in the end, I am putting this data into a database and need there to be some semblance of order.

other code references.
https://www.excelvbasolutions.com/20...-to-excel.html
https://stackoverflow.com/questions/...-word-to-excel
https://www.mrexcel.com/board/thread...-excel.984236/
https://stackoverflow.com/questions/...o-excel-sheets


Basically, looking to have vba run though a word doc and extract all it's tables and place them on one sheet in excel with some type of separator between them (yellow line, doesn't matter).

happy new year's and thanks in advance (stay safe). thanks!

[Norie]

Can you post the code for your current method?

[Excel4444]

Below is portion of the code. there are hundreds of lines since there so many exceptions and clean up that's being done on the tables that come over.
I have added a new example to the workbook (if that's helpful).


then there are a series of formula tests that are done and depending if arguments are TRUE/FALSE then more macros and other type of clean up macros are run.

because the body of the table can be cleaned by "simply" running and re-running clean up macros, the body ends up in a good place, however the headers are random
when using available, published extraction methods.

so the burning question is whether there's another extraction method that preserves headers better or one needs to be built.

Please Login or Register  to view this content.