A previous post, Extracting Word form Data and exporting to Excel spreadsheet, provides the solution to open all the Word files in a folder and copy all the content control data to Excel. This is very close to what I would like to accomplish, but I would like the resulting data to be placed in a named Excel table.
I used Macropod's code as a starting point. Attempted to modify the wdDoc portion of the code to reference the Excel table (tbl_Employees) on the Employees worksheet, but hit a snag.
The code is in the Employees.xlsm file. Example files for extraction are the two *.docx files.
The current code is (sadly) broken.
I appreciate any help someone might offer.
Thanks in advance,
Jewel
