'Excel VBA to update TOC and Table of Tables

I am having trouble getting my excel macro to update my word document (opened from excel) to update the table of tables. I have a table of contents and that gets updated, but the tables does not. I have read that a table of tables is really a TOC, but it still will not update. I currently have this:

wApp.ActiveDocument.TablesOfContents(1).UpdatePageNumbers
wApp.ActiveDocument.TablesOfContents(2).UpdatePageNumbers

(wApp was defined in another part of the code to open a word document)

I am only using page numbers because the titles of the tables never change.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source