Extract word tables (multiple files) into excel using VBA

Hello,

I would greatly appreciate if someone is able to help me with my challenge to automate a lot of manual effort.

I have a large quantity of Word 2010 documents where I want to extract the table information from each document and put it into Excel. Instead of manually doing this, I'm hoping there is a way to automate this using VBA in Excel.

Each word document contains 1 table, with the same layout: 2 columns, 20 rows. The first column is the same in every document, the 2nd column contains the data I want.

I'm looking to run a macro from Excel that would do the following:
1. Automatically open each Word doc (1 at a time). NOTE: All word documents and the Excel file would reside in the same folder
2. Extract the data from the 2nd column of the word table and paste it into Excel (transpose the column into a row, so I can treat all the data like a file)
3. In the last (or first cell) per row, add the Word doc file name
4. Close the current word document, then open the next one in the folder and repeat above steps

So if I had 200 Word documents, then 200 rows would be imported into Excel.

I have code to do this for Excel documents (merging all the Excel files within a folder into 1 document), but have no idea how to do this for Word.

Thanking you in advance for your assistance.

This is an incredible macro but is there away of extracting other columns in the table onto the same line as well as additional tables in the word document some on seprate pages?

Thanks,

I've attached an example Word document my scenairo is the same as above but I want to extract more than one column and have it listed after the last entry of the first column. So the row would look like this:

Joe Bloggs, 12, Male, 18, Penny Lane, Sachs Ville, Hampshire, England, Football, Exampl Data

I am also looking to extract a second table as depicted in the attached Word document which can be on a seprate page.

I may well be asking for the moon but I am hoping this is achievable as I have thousands of legacy documents to go through.

Ideally all in the same row on the same sheet.

Alas I get an error "The requseted member of the collection does not exist" I hit debug and get the following code line highlighted:

Please Login or Register  to view this content.

Any thoughts?

Nope I am afraid still the same error, would a page break before the tables cause the error?

I've sent the form to you hopefully my explanation makes sense, it seems it's one table but looks like two as it is spread over two pages and their is also some merged cells in the form.

Is it possible to also include .docx files as well in the scan?

FANTASTIC!

Thanks Tinbendr.

Wonderful piece of programming, works like a charm. Just run it with fantastic results a whole list of data with a little bit of tweaking a perfect list for my needs. A thousand thanks!

Hi there... how i wish i could get this to work for me! When I run this I receive an error as follows:

"run-time error 13 - type mismatch"

I'm using Office 2013.....

Can anyone help please?

thank you


j

aah what a good idea Tinbendr! My apologies...

Error occurs here:

If FN = False Then GoTo TheEnd

Very very thank you Mr. Tinbendr

You are Genious,
You provide a excelent code
It saved me a lot of time
It can be manipulated
VERY VERY NICE SIR
THANK YOU AGAIN

Excellent Work,

Sir, this code contain extraction of table rows without first header row, what would be change if i want to include first header row also because i faced many of such type of tables.

Waiting for good response

Thanking in advance
Javed

dude , youve just saved my life , just want you to know , thanks