I have a table of file paths and file names for closed word documents. Here is an example:
In each of my closed documents there are 2 tables in the header. I need to extract the value of cell A1 in table 2 of the header, and paste it into my table in column C.
I would prefer to do this without opening the word document, because I may be running this code for hundreds of entries in my table.
Here's my code so far, I have defined the path and filename as strings, and the code it will loop through my table. I've had a little success with pulling data from tables in the body of the document, but I can't figure out how to access the tables in the header.