Copy a table from Word to Excel if table not always in same location in the document

[welchs101]

Hi,

i have a situation where i have a word file. In this word file there are "tables" and i want to copy a specific table in this word file. Now, i have seen others copy tables in word using excel vba but they copy a "specific" table number like copy table(4) which copies i think the 4th table in the file. What if the table i want to copy is not always the 4th table........then how do icopy the correct table. Would bookmarking the table i want to copy help? THoughts?

[ByteMarks]

Bookmarking is one way of doing it.

Insert a bookmark in the first cell of the table and call it something unique.
You can then refer to the table directly using the bookmark.

Please Login or Register  to view this content.

You can also use the Title property.
Right-click your table and click Table Properties to get the Table Properties dialog.
Click the Alt Text tab, enter something unique in the Title field and click OK.

Loop through the tables and check the title to see if it's the one you want, or put this in a function to return the table object.

Please Login or Register  to view this content.

[welchs101]

thanks for the information.

Had another question related to the book marking.

If i assign a book mark to the first cell of a table .......... and the table is not table 1....ie..not table(1)

Then how do i copy the table? I would assume that somehow i need to identify what the table number is but how do i do this? This is kinda
why i was wanting to do the bookmark thing.

Is this why u suggested using tabletitles? It kinda sounded like you would use tabletitles instead of bookmarks.

[ByteMarks]

In the code

Please Login or Register  to view this content.

the "Tables(1)" refers to the table within the range identified by the bookmark, which isn't the same as the table number within the document.
As such it doesn't matter where in the document the bookmarked table is since the the identifier is the bookmark and it should always be Tables(1) of that range.

To copy it, assign it to a variable

Please Login or Register  to view this content.

The you can perform any table operation on t

Table titles are an alternative method. It's more code since you need to loop through all the tables in the document and look at the title to find the right one and you also can't use the bookmarks to check that all the tables are accounted for.
I'd go with the bookmarks as a first choice.