(Solved) – VBA import word table from a specific section into excel


I am creating an excel tool that is to copy a table from a section C.1 of the word document and paste it into a designated sheet in the excel file. The way the word document is set up is such that the only contents of section C.1 is that table.
Sometimes the table in section C.1 is contained in a single page, but sometimes it breaks and spills into the next page. Trying to use the table count/table number approach is really impractical here because of the sheer number of tables in the word file and often the table number of the table of interest also changes, but the section number never changes.
How can I tell VBA to go to the section C.1 and copy over the table to the designated worksheet in my excel file?

Leave a Reply

Your email address will not be published. Required fields are marked *