Locating table # in WORD document with Excel VBA

[submariner18]

Hi all,

I have some background with Excel VBA, but am new to applying VBA to Word, so am looking for help.

My goal is to retrieve a particular table from a bunch of .docx documents and paste them into Excel. I have a working code for most of the process, and have been automating the script to retrieve the 7th table of each word file. However, I found out that the docs actually have different number of tables, and it's not always the 7th table that's the one I want. Fortunately, the table I want is always immediately preceded by the title "III. TableINeed". Does anyone know how I can locate which table number this is based on its title?

To give you an idea of the code, here's a relevant portion:

Please Login or Register  to view this content.

As you can see I now hard code to table 7, but that needs to be dynamic based on the word file.

Thanks!

[patel45]

attach a sample word docx and full code