'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 |
|---|
